Home » SQL & PL/SQL » SQL & PL/SQL » converting char type to date type?
converting char type to date type? [message #299417] Mon, 11 February 2008 23:49 Go to next message
Messages: 99
Registered: August 2007
Location: usa

to_char(sysdate,'MON')from dual,it is working good.the problem is it convert date type to char type.But i want that as date type.What can i do for this one.
Re: converting char type to date type? [message #299424 is a reply to message #299417] Tue, 12 February 2008 00:40 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Ok. Take a deep breath.
Now pretend you don't know your problem and reread your post. It is not really clear, don't you think?
Show us what you want. Show us the data you have and the data you want.
Show what you tried and where (you think) you failed.
Previous Topic: Unknown Issue with Oracle procedure
Next Topic: ROW COUNTER for update, insert and reject... :(
Goto Forum:

Current Time: Tue Jul 25 15:58:55 CDT 2017

Total time taken to generate the page: 0.07127 seconds