Scalar. Converts a bigdatetime to the number of milliseconds since the epoch (midnight, January 1, 1970).
timeToMsec ( time )
time | A bigdatetime. |
Converts a bigdatetime to the number of milliseconds since the epoch (midnight, January 1, 1970). The function takes a bigdatetime as its argument, and the function returns a long representing the number of milliseconds since the epoch (midnight, January 1, 1970 UTC). The function truncates the microseconds that are part of the bigdatetime.
timeToMsec ( unbigdatetime('1970-01-01 01:01:01:002100') ) returns 3661002.