TO_TIMESTAMP function
TO_TIMESTAMP converts a TIMESTAMP string to TIMESTAMPTZ.
Syntax
to_timestamp ('timestamp', 'format')
Arguments
- timestamp
-
A string that represents a timestamp value in the format specified by format.
- format
-
The format for the timestamp value. Formats that include a time zone (
TZ
,tz
, orOF
) are not supported as input. For valid timestamp formats, see Datetime format strings.
Return type
TIMESTAMPTZ
Examples
The following example demonstrates using the TO_TIMESTAMP function to convert a TIMESTAMP string to a TIMESTAMPTZ.
select sysdate, to_timestamp (sysdate, 'HH24:MI:SS') as seconds; timestamp |seconds -------------------|---------------------- 2018-05-17 23:54:51|0001-03-24 18:05:17.0