The TO_TIMESTAMP_TZ function converts text data to a value with the TIMESTAMP_TZ data type.
TIMESTAMP_TZ
TO_TIMESTAMP_TZ (char-exp [, fmt [ 'nlsparam' ] ])
A text expression that you wan to convert.
Specifies the datetime format template to be used to convert the text expression. See Table 9-4, "Datetime Format Elements" for more information about the datetime format template.
When you omit this argument, the function uses the default format of TIMESTAMP_TZ for the object.
Specifies the language in which month and day names and abbreviations are returned. This argument can have this form:
'NLS_DATE_LANGUAGE = language'
If you omit this argument, then this function uses the default date language for your session.