Seconds To Date/Time Function
- 已更新2025-07-30
- 閱讀時間為 3 分鐘
Converts a timestamp value or a numeric value to a cluster of time values. This function loses fractional seconds of precision when converting the timestamp. If you convert date time rec back into a time stamp, the timestamp may not display the exactly correct value.

Inputs/Outputs
time stamp
—
time stamp can be a timestamp or a numeric. If numeric, this number is the time-zone-independent number of seconds that have elapsed since 12:00 a.m., Friday, January 1, 1904, Universal Time [01-01-1904 00:00:00]. The default is the current date and time. If year is before 1904, time stamp is negative.
to UTC (F)
—
to 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.
date time rec
—
date time rec returns the date and time. If to UTC is TRUE, date time rec is in Universal Time. If to UTC is FALSE, date time rec is in the configured time zone for the computer.
|
time stamp
—
to UTC (F)
—
date time rec
—
fractional second
—
second
—