Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
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' ] ])
Arguments
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.
Examples