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: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 13 Jul 2005 20:27:04 +0200
Message-ID: <db3md3$8g7$05$1@news.t-online.com>


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
>

I assume you mean 53 week calendar ,in that case are you asking about format model 'WW' ?

select to_char(sysdate,'WW') from dual;

Best regards

Maxim Received on Wed Jul 13 2005 - 13:27:04 CDT

Original text of this message

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