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!