Wednesday, 7 August 2013

Special date conversion

Special date conversion

My question is simple : I have a date in oracle the format is : 07.08.13 I
want to have : 8/2013
I used
TO_CHAR(SYSDATE, 'MM/YYYY');
the result is : 08/2013
the problem is the zero, is there any conversion solutions ?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)