Home » SQL & PL/SQL » SQL & PL/SQL » convert date
convert date [message #215918] Wed, 24 January 2007 05:12 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
HI
CAN i convert this
Fri Jan 19 16:09:25 EST 2007
TO_DATE or TO_TIMESTAMP
thanxs
Re: convert date [message #215927 is a reply to message #215918] Wed, 24 January 2007 05:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
For a TO_DATE or TO_TIMESTAMP, you'd have to parse out the timezone information first and then add/substract that value from the time component.

If TO_TIMESTAMP_TZ is an option for you, you can seamlessly accommodate for the timezone in the conversion:

select to_timestamp_tz('Fri Jan 19 16:09:25 EST 2007', 'Dy Mon dd hh24:mi:ss TZD rrrr') from dual;
Re: convert date [message #216131 is a reply to message #215927] Thu, 25 January 2007 03:27 Go to previous message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
thanxs it worked
Laughing
Previous Topic: alter materialized view
Next Topic: Update Issue..
Goto Forum:
  


Current Time: Sat Dec 10 18:32:26 CST 2016

Total time taken to generate the page: 0.10666 seconds