Extracting week of the year from Date field

From: <rrachamallu_at_my-dejanews.com>
Date: Thu, 30 Jul 1998 22:07:29 GMT
Message-ID: <6pqqr1$7kv$1@nnrp1.dejanews.com>

Hi, I need to extract the week of the year/month from a date field. The calendar week starts on a sunday and ends on a saturday. For example July 1st ( wednesday) is in the first week of july and july 5th (sunday) is in the second week of july. So I cannot just use (day of the month / 7) to get the week of the month. I am wondering if there is a built-in function in oracle that can be used to do this. If you have a solution for this question, please post the results.

thanks.
reddy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 30 1998 - 17:07:29 CDT