Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date conversion in plsql YYYYMM
"liglin" <liglinlillibli_at_hotmail.com> a écrit dans le message de
news:db9bdb31.0403242235.f75a976_at_posting.google.com...
> 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
trunc(TR.TR_BEG_DATE,'MONTH')
Regards
Michel Cadot
Received on Thu Mar 25 2004 - 00:55:57 CST