Home » SQL & PL/SQL » SQL & PL/SQL » How to convert MM/DD/YYYY time format to YYYY-MM-DDTHH:mm:ss.000Z (merged 3) (10g)
How to convert MM/DD/YYYY time format to YYYY-MM-DDTHH:mm:ss.000Z (merged 3) [message #422677] Fri, 18 September 2009 06:13 Go to next message
srinivasvkumar
Messages: 1
Registered: September 2009
Location: Bangalore
Junior Member
Hi I am stuck in one date conversion.

the output needed is in this format 2009-05-13T10:00:00.000Z.

the input is sysdate. I tried TO_TIMESTAMP_TZ, and even tried to use create_date, but nothing paid off.

Please let me know how to achieve this.. with a sample query.

Regards
Srinivas
Re: How to convert MM/DD/YYYY time format to YYYY-MM-DDTHH:mm:ss.000Z (merged 3) [message #422681 is a reply to message #422677] Fri, 18 September 2009 06:19 Go to previous message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use TO_CHAR.

Regards
Michel
Previous Topic: to calculate exact year of experiance for employee
Next Topic: Error PLS-00103
Goto Forum:
  


Current Time: Fri Sep 30 19:18:52 CDT 2016

Total time taken to generate the page: 0.22749 seconds