Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

TO_TIMESTAMP Function

TO_TIMESTAMP converts a TIMESTAMP string to TIMESTAMPTZ.

Syntax

Copy
to_timestamp ('timestamp', 'format')

Arguments

timestamp

A string that represents a time stamp value in the format specified by format.

format

The format for the timestamp value. Formats that include a time zone (TZ, tz, or OF) are not supported as input. For valid time stamp formats, see Datetime Format Strings.

Return Type

TIMESTAMPTZ