Posted by toedipper on 09/14/05 01:23

Hello,

MYsql and PHP

If I want to extract data with todays date then it's 'where blab blah =
current_date()'

For yesterday it's 'where blah blah = current_date()-1'

But can anyone tell me how to extract all data from the start of the
current week? Is there any way in Mysql to work out the start of the
current week?

The current month?

Year?

Thanks,

rg

www.pocketpcheaven.com

[Back to original message]