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: sql matrix report
Next Topic: Exception handling for Package Variables
Goto Forum:

Current Time: Tue Mar 28 07:16:09 CDT 2017

Total time taken to generate the page: 0.08077 seconds