Selecting the next 24 hours - timestamps..

[Scooby08]

I had this query working before to select all records with a date that was within the next 24 hours, but it wasn't with timestamps..

 

SELECT * FROM table WHERE (Time_TS BETWEEN NOW() AND NOW() + INTERVAL 24 HOUR)

 

My timestamps are retrieved from an XML file and look like this: 1265414700000

 

What do I need to change for timestamps? I also tried this:

 

SELECT * FROM table WHERE (Time_TS BETWEEN CURRENT_TIMESTAMP() AND CURRENT_TIMESTAMP() + INTERVAL 24 HOUR)

 

Thanks!

 

[RussellReal]

current_timestamp() is an int not a date, so increasing it by an interval will probably not work.

 

try CURRENT_TIMESTAMP() + (60 * 60 * 24)

[Scooby08]

Thanks for the reply! Unfortunately I couldn't get that one to work.. I'm gonna try formatting the timestamp to a datetime format before inserting into the database and see if that works out..

[Scooby08]

Well what do you know.. Works great now with my original query..