Date/Time

[Hai Nguyen]

Hi,

I am newbie both in php/mysql. I have php version: 4.3.8 and mysql version: 4.0.20 installed.

I am working on a NFL football pool. I have a table called 'schedule' with a column 'start_date' which is a date type.

As of right now, they can submit there picks but only up midnight which is the start date of the game. What I want to do is make it so they can submit at 8 am.

$query = "select * from schedule where start_ate <= 'DATE_ADD('start_date', INTERVAL, 8 HOUR)'";

Since 'start_date' is a date type, whould this be a problem and not a datetime type?

What is the best way to do this? Any suggestions is greatly appreciated.

Thanks in advanced?

-haiN