Re: Weeknumber of a year

On 19 Jul 2006 13:23:32 -0700, purush.venkat_at_gmail.com wrote:

>Hi Experts,
>
>I have a question where in i have to get a weeknumber as follows :
>
>Week Week Ending
>
>1 1/5/2006
>2 1/12/2006
>3 1/19/2006
>4 1/26/2006
>5 2/2/2006
>6 2/9/2006
>
>etc. so on and so forth.
>
>Can anyone help me with this in ORACLE 9i please?
>
>Thanks,
>-- Tom .

Please look up the WW date format model and the IW format model under 'Date format models' in the 'SQL reference manual'

Please avoid asking doc questions, try to be somewhat more industrious and search on http://tahiti.oracle.com *prior* to posting.

--
Sybrand Bakker, Senior Oracle DBA