Query all records with a particular date

[over9k]

SELECT * FROM `schedule` WHERE `date`='2010-01-01'
also tried:
SELECT * FROM `schedule` WHERE `date`='2010-01-01 *'
SELECT * FROM `schedule` WHERE `date`='2010-01-01 *:*:*'

 

I'm trying to get all records from a certain day disregarding the time portion but the above code is only returning one record when there are many records for a particular day

 

A record looks something like:

[pre]

id          date

0000      0000-00-00 00:00:00

[/pre]

The date field is type datetime

 

 

 

MySQL server version -- 5.1.30

[PFMaBiSmAd]

SELECT * FROM `schedule` WHERE DATE(date) ='2010-01-01'

[over9k]

Thanks PFMaBiSmAd,

 

it worked perfectly I just found the mySQL date functions.

 

I have a second question:

 

Is there any problem with using datetime type as a primary key if the only precision needed is to the minute?

[fenway]

PKs should usually be integers.