MySQL Challenge Contest
debiprasad.net
debiprasad.net
Prize: getting a job offer for a very unspecific web company based in India. Yay?
But, in the spirit of being constructive, he should probably forgo solving this in SQL, have PHP generate the date, then use the date as part of the SQL WHERE clause.
BTW, the job is offered to the people who need a job (in India). You don't worry, you must have a good job.