Getting the week number for a given date

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by andrewhallam on 30 October 2009

I am currently migrating our product from SQL SERVER to ORACLE and have the following issue.
Basically I’m just trying to get the year week number for a given date but I’m having trouble with Oracle as it seems to think that the weeks run from Thursday to Thursday?. I presume this is something to do with the fact that the first day of the year was Thursday?

Learnmore Microsoft SQL Server databases hereShould you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting