in reply to unix time and dates with mysql
select * where $date1 < dateCol and $date2 > dateCol
dateCol is the column that holds all your dates and $date1 and $date2 are the inputted dates. I believe that MySQL will hold the full date, including time.
UPDATE: I believe Cayenne is correct. From the MySQL documentaion: "The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format."
|
|---|