SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Week num in Oracle database shows different compared to excel.

845345Mar 24 2011 — edited Mar 24 2011

Hi

We are trying to import all data from excel into Oracle database. In that situation we used below SQL

select to_char(to_date('24/03/11','dd/mm/yy'),'ww') from dual;

result is :12

same in excel weeknum(24/03/11,1) .
Result is 13

I have a bit confusion. What i found was oracle considering week starts from saturday.
And excel week starts from Monday thats making difference.

Please help me how to fix this issue in Oracle database .
Thanks in Advance.

Regards
Sandeep

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2011

Added on Mar 24 2011

4 comments

1,873 views