timeToUsec()

Scalar. Converts a bigdatetime to the number of microseconds since the epoch (midnight, January 1, 1970).

Syntax

timeToUsec ( time )

Parameters

time

A bigdatetime.

Usage

Converts a bigdatetime to the number of microseconds 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 microseconds since the epoch (midnight, January 1, 1970 UTC).

Example

timeToUsec ( unbigdatetime ('1970-01-01 01:01:01.000001')) returns 3661000001.