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
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi

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
Frank
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: Sat Dec 10 03:00:04 CST 2016

Total time taken to generate the page: 0.06702 seconds