Converts a timestamp value or a numeric value to a date and time string in the time zone configured for the computer. The function interprets timestamp and numeric values as the time-zone-independent number of seconds that have elapsed since 12:00 a.m., Friday, January 1, 1904, Universal Time.


icon

Inputs/Outputs

  • cenum.png date format (0) —

    date format selects the appearance of the date string.

    Date formats vary with your system configuration. To use a different date format, use the Format Date/Time String function.

    0short—1/21/94
    1long—Friday, January 21, 1994
    2abbreviated—Fri, Jan 21, 1994
  • catrn.png 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.

  • cbool.png want seconds? (F) —

    want seconds? controls the display of seconds in the time string.

  • istr.png date string —

    date string is the string returned by the function according to the specified date format.

  • istr.png time string —

    time string returns the string formatted according to the configured time zone for your computer. want seconds? controls whether the string includes seconds.