Oracle PL/SQL: Date Functions: NEW TIME - Returns the date and time in time zone zone2 when date and time in time zone zone1 are date.<br />

Quick Search:

Oracle PL/SQL: Date Functions: NEW_TIME

Jump to:

Category: >> Oracle PL/SQL >> Date Functions: NEW_TIME

<< last

next >>

Snippet Name: Date Functions: NEW_TIME

Description: Returns the date and time in time zone zone2 when date and time in time zone zone1 are date.

NOTE: Before using this function, you must set the NLS_DATE_FORMAT parameter to display 24-hour time.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SELECT NEW_TIME(TO_DATE( '11-10-99 01:23:45',
'MM-DD-YY HH24:MI:SS'), 'AST', 'PST') "New Date and Time"
FROM dual;
 
ALTER SESSION SET NLS_DATE_FORMAT =
'DD-MON-YYYY HH24:MI:SS';
 
SELECT NEW_TIME(TO_DATE('11-10-99 01:23:45',
'MM-DD-YY HH24:MI:SS'), 'AST', 'PST') "New Date and Time"
FROM dual;