Home » SQL & PL/SQL » SQL & PL/SQL » change the format from APR 07 to 042007
change the format from APR 07 to 042007 [message #323146] Tue, 27 May 2008 08:03 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

suppose there is column BILL_MONTH varchar2(20)
in wich data stored like:
MAY 08
APR 07
JUN 04
but there is some other data like APRIL 08,JANUARY 06 etc
Now i want to replace APR 07 with 042007 (MMYYYY) and MAY 08 with 052008
but i want to replace APRIL 08 ,JANUARY 06 with NULL

Please suggest!
Re: change the format from APR 07 to 042007 [message #323148 is a reply to message #323146] Tue, 27 May 2008 08:06 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read "Issue: Different Date formats in the same cloumn in a table" and take it as example to build your solution.

Previous Topic: UTL_FILE
Next Topic: Trigger not firing
Goto Forum:

Current Time: Thu Oct 27 00:53:51 CDT 2016

Total time taken to generate the page: 0.10344 seconds