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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 19 Jul 2003 10:59:56 +0200
Message-ID: <5kthhvgaa25i16c3bmb0ajmuc153uhojr2@4ax.com>

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

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 19 2003 - 03:59:56 CDT