Re: get what week a date falls in based on 52 week calendar
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 13 Jul 2005 20:27:54 +0200
Message-ID: <h7nad1hdsu272em4p2jsq3u29avpok2df6_at_4ax.com>
Date: Wed, 13 Jul 2005 20:27:54 +0200
Message-ID: <h7nad1hdsu272em4p2jsq3u29avpok2df6_at_4ax.com>
On 13 Jul 2005 11:16:47 -0700, jeffchirco_at_gmail.com 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?
>Thanks.
>
>Jeff
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 DBAReceived on Wed Jul 13 2005 - 20:27:54 CEST