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

Home -> Community -> Usenet -> c.d.o.server -> Number of the week TO_CHAR(DATE,'YYYY/WW')

Number of the week TO_CHAR(DATE,'YYYY/WW')

From: Yves LUDWIG <yve_at_free.fr>
Date: Sat, 19 Jul 2003 08:08:54 +0200
Message-ID: <3f18e072$0$8080$626a54ce@news.free.fr> 





I'm not satified with the week number provided by Oracle.
The documentation indicates that the TO_CHAR function with the WW parameter
it returns the number of weeks since the 1st day of the week.
In Microso*t, it is possible to parameter the week (the week starts on
monday, on sunday, the 1st week starts with at least 3 days...)



Is is possible to parameter Oracle to provide a relevant week number ?
Received on Sat Jul 19 2003 - 01:08:54 CDT












Original text of this message













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