%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}))

Parts

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