TO_TIMESTAMP_TZ

The TO_TIMESTAMP_TZ function converts text data to a value with the TIMESTAMP_TZ data type.

Return Value

TIMESTAMP_TZ

Syntax

TO_TIMESTAMP_TZ (char-exp [, fmt [ 'nlsparam' ] ])

Parameters

char-exp

A text expression that you wan to convert.

fmt

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.

nlsparam

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.

Examples

Example 8-146 Converting Text Data to TIMESTAMP_TZ DAta

SHOW TO_TIMESTAMP_TZ ('2006-03-26 7:33:00 -4:00', 'YYYY-MM-DD HH:MI:SS TZH:TZM')
26-MAR-06 07.33.00 AM -04:00