Re: Is there an easy way to get the start date of the current week?

Is this purely an intellectual exercise or is there a reason you don't just subtract the right number of days from your start date to get the beginning of the week?

It is required to be able to run a report which is querying a mysql database for records of a particular week. Not a problem if the report is run on say a Monday it would return the required info but if say it was run on a Wednesday it would contain part of the current week and part of the following week using mysql's interval week.

EG: xxxxx AND `s_date` >= DATE_SUB( CURDATE( ) , INTERVAL 8 WEEK ) AND `s_date` < DATE_SUB( CURDATE( ) , INTERVAL 7 WEEK ) So I need to replace CURDATE( ) with the date of the Sunday of the week the report is being run preferably in the format YYYY-MM-DD

Comment on Re: Is there an easy way to get the start date of the current week?

Replies are listed 'Best First'.
Re^2: Is there an easy way to get the start date of the current week? by james2vegas (Chaplain) on Aug 21, 2010 at 14:51 UTC
Use MySQL date functions, the WEEK function goes beyond what ISO8601 specifies, so it will probably work for you, in combination with the WEEKDAY and DATE_SUB functions.	[reply]
Re^2: Is there an easy way to get the start date of the current week? by roboticus (Chancellor) on Aug 21, 2010 at 14:32 UTC
ramjamman: In this case (querying a database), I'd suggest doing the date manipulation in SQL rather than perl. ...roboticus	[reply]