How to know the date is first,second,third weeks...

Thread view:

weetat - 13 Aug 2007 04:52 GMT

Hi all,

I have column in the database , release_date . The release_date
column is to capture when the data are first released to our client.

Our client want us to check if for example the release_date is 9
August 2007 is on the first week of the month. However it did not the
referred to month but to release_date.

for example :

Prod reelase_date

A 02 Aug 2007
B 23 Aug 2007
C 09 Aug 2007
D 02 Aug 2007
E 06 Aug 2007

Prod A and Prod B are in the first week product of the month.

Anyone have any suggestions or ideas ?

Thanks

wee tat

Reply to this Message

Jacky - 13 Aug 2007 10:02 GMT

> Hi all,
>
[quoted text clipped - 22 lines]
>
> wee tat

I don't think the database system supply such date function to us.
You can get the query condition by java at first.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...