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,
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**]( function which is a Type Conversion function provided by Denodo Platform. `cast('<datatype>',1974873205059) ` You can take a look at the [Datetime 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