Home » SQL & PL/SQL » SQL & PL/SQL » help in converting date...
help in converting date... [message #184806] Fri, 28 July 2006 02:20 Go to next message
dockies
Messages: 9
Registered: June 2006
Junior Member
is this possible? i want to convert the mm/dd/yyyy date format to mm/yyyy only... is there anyway i can do this... please help i really need it. tnx
Re: help in converting date... [message #184809 is a reply to message #184806] Fri, 28 July 2006 02:32 Go to previous messageGo to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member

select to_char(to_date('10/10/2006','MM/DD/YYYY'),'MM/YYYY') from dual
Re: help in converting date... [message #184810 is a reply to message #184806] Fri, 28 July 2006 02:35 Go to previous message
dockies
Messages: 9
Registered: June 2006
Junior Member
HEY THANKYOU VERY MUCH
Previous Topic: Regarding materialized view
Next Topic: insert the data based on prevoius columns
Goto Forum:
  


Current Time: Fri Dec 09 15:41:14 CST 2016

Total time taken to generate the page: 0.26356 seconds