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

Home -> Community -> Usenet -> c.d.o.tools -> Re: get what week a date falls in based on 52 week calendar

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@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 DBA


Received on Wed Jul 13 2005 - 13:27:54 CDT












Original text of this message













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