Format UTIME in SQL

Hi folks,

I'm doing an import from flat file to E1, through SQL.
The data I get from CSV is '12/24/2013 18:30:15' and a timezone field (-5 or +4). I need this to be converted to UTIME format through SQL.

Any pointers towards this would be helpful.

Hello Deepesh,

This URL may help to solve the issue.
http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions112.htm#SQLRF51538

Example:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

SELECT NEW_TIME(TO_DATE('11/10/09 01:23:45', 'MM/DD/YY HH24:MI:SS'), 'AST', 'GMT')
"New Date and Time"
FROM DUAL;

New Date and Time
--------------------
09-NOV-2009 21:23:45

Thanks Vijay! NEW_TIME would help me to do the conversion from UTC to other timezones.

I wanted the output to be in UTC. Following is what I found works for me in Oracle DB

<font color="red">SYS_EXTRACT_UTC(TIMESTAMP <font color="blue">'2014-03-05 23:19:00 +05:30'</font>)</font>
Where +5:30 is the timezone from the file for IST.