%TIMESTAMP Function

%TIMESTAMP built-in function converts the value of an expression from character, numeric, or date data to type timestamp. If no expression is specified, the current system timestamp is returned.

 **%TIMESTAMP**  ((Expression {, *ISO | *ISO0}))

Parameters

Expression

Optional. Expression can be character, numeric, or date data to be converted to type timestamp.

*ISO, *ISO0

Optional. This is the timestamp format.

  • For character expressions, *ISO or *ISO0 is valid.
  • For numeric expressions, you need not specify the timestamp format as only *ISO (the default) is valid.
  • For date expressions, do not specify the timestamp format. The date is converted from it’s current format to *ISO.

Remarks

If no Expression is specified, the current system timestamp is returned. Regardless of the input format, the resulting value is *ISO format.

See Also

Built-in Function Overview

Timestamp Data Types

%TIME

%DATE