Simple query using a timestamp field and a date range
Posted on 2011-03-10
New to mySQL. This is on a Linux box running MySQL 5.1.52
How do I do a simple query to retrieve e a date range from a timestamp field?.
The field is named time . I know, but I didn't name it. This is what I need to do iinteractively.
Select * from journal
WHERE time > 2009/12/31 AND
time < 2010/12/31
I also need to do the same in a form with two php form fields, startdate and endate, formatted as yyyy-mm-dd
Select * from diaries
WHERE time >startdate AND
time < enddate