Home » SQL & PL/SQL » SQL & PL/SQL » date format related query
date format related query [message #214581] Wed, 17 January 2007 03:13 Go to next message
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
I have date in format 17-JAN-07 but i am calling an API where i need to pass this date as 17-JAN-2007. How do i make the conversion. The parameter which will be receiving this value is also DATE type. Please help
Re: date format related query [message #214583 is a reply to message #214581] Wed, 17 January 2007 03:14 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Then you'll need to format on the front end. A date has no format.

Previous Topic: Tree Walking
Next Topic: Convert a numeric value to INTERVAL YEAR in Oracle8i Enterprise Edition Release 8.
Goto Forum:

Current Time: Sun Aug 20 10:43:17 CDT 2017

Total time taken to generate the page: 0.05282 seconds