Week of the Month

sivasankari_kv

Is there a mysql function which will return the week of the month given a date
ex:

date = 01-10-2003
week = 1

date = 05-10-2003
week = 2

HalfaBee

No, but this gives you the answer

$weekOfMonth = (date( 'd' , $date )%7) + 1;

This of course depends on what you mean by week.

Had me stumped for about 2 seconds.

HalfaBee

________

I don't think there is any function that will return the week of a month, but you can use the week function and find out what week the first week of a month is.
Eg.:
SELECT (WEEK('2003-10-05')-WEEK('2003-10-01'))+1;

The result will be 2. This function get the weeknumber of the first week of the month - the week of any date of the month. The reason why we add 1 is because the first week must be week 1 and not week 0.

If you don't have to use mysql, HalfaBee example would maybe be easier!

HalfaBee

This does it, but assumes weeks start on monday.

$date = $zip;
$fdate = preg_replace( '/([0-9]+)-([0-9]+)-([0-9]+)/','\3-\2-\1' , $date );
$sdate = preg_replace( '/([0-9]+)-([0-9]+)-([0-9]+)/','\3-\2-1' , $date );
$udate = strtotime( $fdate );
$sdate = strtotime( $sdate );
$monthStart = date( 'W',$sdate );
$weekOfMonth = date( 'W' , $udate ) - $monthStart  + 1;

sivasankari_kv

Hi Halabee

I din't try your second answer ,
i tries that date (d, $date)

is $date = timestamp or just date
when i tried this

$date = '15-10-2003';
$weekofmonth = (date(d, strtotime($date))%7)+1;
print $weekofmonth;

it printed 5

where as 15 falls in the 3rd week of october

HalfaBee

strtotime doesn't like the date in your format.
It needs to be backwards dd-mm-yyyy.

The second script works, but Monday is the start of the week.

The mysql solution is good too.

date() takes UNIX timestamps.

$fdate = preg_replace( '/([0-9]+)-([0-9]+)-([0-9]+)/','3-2-1' , $date ); 
$udate = strtotime( $fdate );

converts your date format to unix type.

HalfaBee

Drakla

sivasankari.kv you might also want to check your replies to your exact same thread in the database board. And also take note that it's frowned upon to post the same question in more than one board.