From m204wiki
Jump to navigation Jump to search

Convert datetime number of seconds to string

Note: Many $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for the $Sir_NS2Date function is SecondsToString.

The $Sir_NS2Date function expects a numeric datetime argument containing a number of seconds since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. $Sir_NS2Date accepts an optional error control string and returns the null string if an error is detected.


%dat = $Sir_NS2Date(datn, fmt, errctl)

Syntax terms

%dat Set to the datetime value string, using format specified by fmt, corresponding to datn, unless an error is detected.
datn Datetime number containing a signed number of seconds since January 1, 1900.
fmt Datetime format string. Refer to "Datetime string formats" for an explanation of valid datetime formats and valid datetime values.
errctl Optional error control string; refer to "Datetime error handling".


The following fragment prints the string 07/31/84:

%X = $Sir_Date2NS('8407301230', 'YYMMDDHHMI') * Add 15 hours: %X = %X + 60 * 60 * 15 PRINT $Sir_NS2Date(%X, 'MM/DD/YY')

Usage notes

  • The inverse of this $function is $Sir_Date2NS.
  • $Sir_NS2Date returns a null string in the following cases:
    • fmt is not a valid datetime format.
    • datn out of range.

Products authorizing $Sir_NS2Date