SQL date query

[pdelite]

I want to do a search on a certain table for instance which I will call people and the column name is birthday. I want to see if there is anybody born on '29-feb-2007'. I need to use that date format. Any suggestion on how to write this query?

[r035198x]

I want to do a search on a certain table for instance which I will call people and the column name is birthday. I want to see if there is anybody born on '29-feb-2007'. I need to use that date format. Any suggestion on how to write this query?

MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format so you might have to convert your date first before doing the search.

[pradeep kaltari]

I want to do a search on a certain table for instance which I will call people and the column name is birthday. I want to see if there is anybody born on '29-feb-2007'. I need to use that date format. Any suggestion on how to write this query?

Hi,
I guess this link might helpful:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Regards,
Pradeep