Scalar. Converts a bigdatetime to the number of seconds since the epoch (midnight, January 1, 1970).
timeToSec ( time )
time | A bigdatetime. |
Converts a bigdatetime to the number of seconds 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 seconds since the epoch (midnight, January 1, 1970 UTC).The function truncates the milliseconds or microseconds that are part of the bigdatetime.
timeToSec ( unbigdatetime('1970-01-01 01:01:01:000000') ) returns 3661.