Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Date format for 8/4/97, plus TRUNC('ww') question
TO_CHAR(some_date, 'Dy fmMM/') || LTRIM(TO_CHAR(some_date, 'DD/YY'), '0')
2. The reference book says TRUNC(some_date, 'ww') should always give a Monday. Mine always seems to give a Wednesday. Huh?
Thanks,
Kevin
Received on Tue Aug 05 1997 - 00:00:00 CDT
![]() |
![]() |