Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Date conversion in plsql YYYYMM
Hello,
I would like to convert a date from YYYYMMDD To YYYYMM01.
Is there a simpler way than:
TO_DATE(TO_CHAR(TO_DATE(TR.TR_BEG_DATE, 'YYYYMM'),'YYYYMM')|| ‘01', ‘YYYYMMDD');
Thanks,
Liglin Received on Thu Mar 25 2004 - 00:35:52 CST