You can translate the question and the replies:

How to convert a date in string format to interval date

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,
user
15-01-2021 15:55:19 -0500

1 Answer

Hi, If I want to convert the time in milliseconds to a date or time value, I would use the [**CAST**](https://community.denodo.com/docs/html/browse/8.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast) function which is a Type Conversion function provided by Denodo Platform. `cast('<datatype>',1974873205059) ` You can take a look at the [Datetime Processing Functions](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions) section of Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
18-01-2021 05:54:50 -0500
You must sign in to add an answer. If you do not have an account, you can register here