mysql query to track the dateline (UNIX_TIMESTAMP)
Posted on 2008-11-06
I have a mysql database where date and time is stored in the dateline format (UNIX_TIMESTAMP). I need a sql query which should pull up the data entered between two given timeline.
In order to search the data which is entered today i use the following sql query:
SELECT * FROM table WHERE dateline > UNIX_TIMESTAMP(CONCAT(CURDATE(), ' ', '00:00:00'))
Now what i am looking for is a sql query to pull up the data entered between two given dates.