Re: get what week a date falls in based on 52 week calendar
Date: Wed, 13 Jul 2005 20:27:04 +0200
> 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?
I assume you mean 53 week calendar ,in that case are you asking about format model 'WW' ?
select to_char(sysdate,'WW') from dual;
Maxim Received on Wed Jul 13 2005 - 20:27:04 CEST