Scalar. Converts a given value to a bigdatetime.
to_bigdatetime ( value ) to_bigdatetime ( value, format )
| value | A string, float, long, or bigdatetime. Strings must be in the format specified by the format argument. Numeric values represent the number of microseconds from the epoch (midnight, January 1, 1970 UTC). |
| format | A format string. Only valid if the value is a string. Must be one of the format codes for a bigdatetime. See "Date/Time Format Codes" for more information. |
Converts a given value to a bigdatetime. The function takes a float, a long, or a string (and associated format string) as its argument, and the function returns a bigdatetime. Note that the function can also take a bigdatetime as its argument, but it will return the same bigdatetime.
to_bigdatetime(3600000000) returns 1970-01-01 01:00:00.000000.
to_bigdatetime('02/19/2010 10:15', '%m/%d/%Y %H:%M') returns 2010-02-19 10:15:00.000000.
to_bigdatetime('07/19/2010 10:15 -07.00', 'MM/DD/YYYY HH:MI TZH:TZM') returns 2010-07-19 03:15:00.000000.