Home » SQL & PL/SQL » SQL & PL/SQL » Need a query...!!!!
Need a query...!!!! [message #379015] Sat, 03 January 2009 22:24 Go to next message
chase53
Messages: 6
Registered: January 2009
Junior Member
Hi,

I need a query that takes the string 'February 06, 1968' and outputs '06-FEB-68'

Thanks
Re: Need a query...!!!! [message #379016 is a reply to message #379015] Sat, 03 January 2009 22:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above.


When all else fails, you should try to RTFM below
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
Re: Need a query...!!!! [message #379024 is a reply to message #379015] Sun, 04 January 2009 00:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TO_DATE
TO_CHAR
Datetime Format Models

Regards
Michel

[Edit: Fix URLs]

[Updated on: Sun, 04 January 2009 06:16]

Report message to a moderator

Previous Topic: how can i select range of numbers between two numbers
Next Topic: Insert data over network.
Goto Forum:
  


Current Time: Sun Dec 04 16:58:51 CST 2016

Total time taken to generate the page: 0.04187 seconds