Description
Returns the number of milliseconds elapsed since 1970-01-01T00:00:00Z for a datetime value.Syntax
ToMilliSeconds(datetime_expression)
Examples
ToMilliSeconds(ToDate('2015-02-04T13:27:23.950Z')) returns 1423056443950
Convert a datetime value to the number of milliseconds elapsed since the Unix epoch (1970-01-01T00:00:00Z). Use for timestamp arithmetic in ETL.
ToMilliSeconds(datetime_expression)
ToMilliSeconds(ToDate('2015-02-04T13:27:23.950Z')) returns 1423056443950
Was this page helpful?