Re: get what week a date falls in based on 52 week calendar

From: Sybrand Bakker <>
Date: Wed, 13 Jul 2005 20:27:54 +0200
Message-ID: <>

On 13 Jul 2005 11:16:47 -0700, wrote:

>Is there a way to get the week number that a date falls in based on the
>52 week calendar? Is there a function or how could I obtain this?

to_char(<date expression>,'WW')

Please refer to the SQL reference manual, and the to_char function prior to asking this sort of questions.

Sybrand Bakker, Senior Oracle DBA
Received on Wed Jul 13 2005 - 20:27:54 CEST

Original text of this message