Date/Time To Seconds Function
- Updated2025-07-30
- 3 minute(s) read
Creates a timestamp from a set of individual values that specify a date and time.
Use the To Double Precision Float function to convert the timestamp value to a lower precision, floating-point number. The number is measured as the number of seconds that have elapsed since 12:00 a.m., Friday, January 1, 1904, Universal Time, assuming DST is set to 1.

Inputs/Outputs
date time rec
—
date time rec is the date and time to convert. If is UTC is TRUE, date time rec is in Universal Time. If is UTC is FALSE, date time rec is in the configured time zone for the computer.
is UTC (F)
—
is UTC specifies if date time rec is in Universal Time or in the configured time zone for the computer. If TRUE, date time rec is in Universal Time. The default is FALSE.
time stamp
—
time stamp is the time that represents the date and time specified by the individual values in date time rec. If year and month are out of range, the results are unpredictable. |
date time rec
—
fractional second
—
second
—
is UTC (F)
—
time stamp
—