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

On Sat, 19 Jul 2003 10:59:56 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On Sat, 19 Jul 2003 08:08:54 +0200, "Yves LUDWIG" <yve_at_free.fr> wrote:
>
>>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 ?
>>
>>
>
>You can use the IW mask for the ISO weeknumber in use in Europe,
>requiring at least 3 days in a week.
>Other than that you can safely assume when it's not documented it's
>not there, and you shouldn't request the group to read the
>documentation for you.
>
>If you are still not satisfied with the weeknumber submit an
>enhancement request
>

Or even better : Write your own user-defined function :-)

• Kenneth Koenraadt
  >
  >Sybrand Bakker, Senior Oracle DBA
  >
  >To reply remove -verwijderdit from my e-mail address