Jump to content

Help with time based query


mrobinson83

Recommended Posts

Hi there,

 

I'm a newbie to MYSQL and PHP so please go easy!

 

I am having trouble executing the following query...

 

SELECT * FROM Status_Lead WHERE `Start_Time` < DATE_ADD(NOW(), INTERVAL 60 MINUTE);

 

I am trying to select all records that have a timestamp of greater than one hour. Currently the query seems to select everything in that table. Your help would be most appreciated!

Link to comment
https://forums.phpfreaks.com/topic/96894-help-with-time-based-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.