Home » SQL & PL/SQL » SQL & PL/SQL » Date conversion function
Date conversion function [message #241615] Wed, 30 May 2007 03:27 Go to next message
pratap.babar
Messages: 4
Registered: May 2007
Location: India
Junior Member

is there any date conversion function which converts the integer value into the date field .

i have the 6 digit number .
Re: Date conversion function [message #241625 is a reply to message #241615] Wed, 30 May 2007 03:54 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
That depends on the composition of the number. What's the layout?

This could do the trick:
TO_DATE(TO_CHAR(yournumber),'yourdateformat')


MHE
Previous Topic: unable to audit
Next Topic: Call a procedure
Goto Forum:
  


Current Time: Sat Dec 03 01:12:08 CST 2016

Total time taken to generate the page: 0.10612 seconds