Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Date format for 8/4/97, plus TRUNC('ww') question

Date format for 8/4/97, plus TRUNC('ww') question

From: Kevin Bourrillion <kevin_at_cpm.com>
Date: 1997/08/05
Message-ID: <5s622l$3pl$1@grandprime.binc.net>#1/1

  1. Why does the date format 'fmMM' work as expected (yielding '8' today), but 'fmDD' does not (yielding '04')? Do I really have to do THIS to get the date to come out nicely?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US