Forum Moderators: open

Message Too Old, No Replies

compare php dates

         

ayushchd

5:50 pm on Oct 27, 2007 (gmt 0)

10+ Year Member



Hi.
If I have a variable that has a unix timestamp.
and in my database i have a column which store the date as October 22, 2007

How do I write a query to get all the records that are greater than or equal to 1184609700?

Discovery

8:53 am on Oct 30, 2007 (gmt 0)

10+ Year Member



Hi,

What you do, Read date from database as
UNIX_TIMESTAMP() [dev.mysql.com] and compare date at database level or do it at PHP level date and time [in.php.net]