OraFAQ Forum: SQL & PL/SQL » correct week number

Home » SQL & PL/SQL » SQL & PL/SQL » correct week number (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

correct week number [message #605553]

Fri, 10 January 2014 08:15

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

Dear All,

I have to display some data based on week number but when i query on date it give wrong week no.
select to_char(to_date('07-jan-2014','dd-mon-yyyy'),'ww') from dual;
it says 1 which is wrong as it falls in 2nd week. How can i get the correct week

Please advice.

Report message to a moderator

Re: correct week number [message #605554 is a reply to message #605553]

Fri, 10 January 2014 08:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can i get the correct week
on which date does week 2 start for you & why?

[Updated on: Fri, 10 January 2014 08:26]

Report message to a moderator

Re: correct week number [message #605556 is a reply to message #605554]

Fri, 10 January 2014 08:29

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

week 2nd started from monday i,e 06-jan-2014. 1st week actually had 2 dyas in 2013 and 01-jan fall in wed . i mean as per general calendar also week is starting from monday so 07-jan is tuesday and fall in 2nd week

Report message to a moderator