Description: Converts a string datatype to a TIMESTAMP WITH TIME ZONE datatype.
Note: This function does not convert character strings to TIMESTAMP WITH LOCAL TIME ZONE. To do this, use a CAST function.
The optional fmt specifies the format of char. If you omit fmt, then char must be in the default format of the TIMESTAMP WITH TIME ZONE datatype. The optional 'nlsparam' has the same purpose in this function as in the TO_CHAR function for date conversion.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_TIMESTAMP(<date_string>,<format mask>,<NLS_PARAMETER>)RETURNTIMESTAMPWITH TIMEZONE
-- convert a character string to a -- value of TIMESTAMP WITH TIME ZONE:SELECTTO_TIMESTAMP_TZ('1999-12-01 11:00:00 -8:00','YYYY-MM-DD HH:MI:SS TZH:TZM')FROM DUAL;TO_TIMESTAMP_TZ('1999-12-0111:00:00-08:00','YYYY-MM-DDHH:MI:SSTZH:TZM')--------------------------------------------------------------------
01-DEC-99 11.00.00.000000000 AM -08:00
-- also:SELECT order_id, line_item_id,CAST(NULLASTIMESTAMPWITH LOCAL TIMEZONE) order_date
FROM order_items
UNIONSELECT order_id,TO_NUMBER(NULL), order_date
FROM orders;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.
