[RESOLVED] MySQL timestamp query

[PureDrive]

I have a table which contains a timestamp and a php function that is supposed to obtain all rows of a specific table from some start_date to some end_date specified by the user. The table's timestamp field is generated by the mysql UTC_TIMESTAMP() function every time I insert a new row - it takes this format: YYYY-MM-DD HH:MM:SS.

I need to be able to get all entries of the table from some start date to some end date and they must be sorted in order from earliest occurrence to latest one. The date entered by the user is obviously not going to take the UTC format but would rather be something like MM-DD-YYYY. Any suggestions how to perform such a query (if possible without some php pre-parsing) and how to do it efficiently? Thanks!

[bradgrafelman]

SELECT col1, col2
FROM myTable
WHERE date_col BETWEEN '2007-01-01' AND '2007-12-01'
ORDER BY date_col ASC

That'd be the general query I'd suggest... you can fill in the date values accordingly (user input, predefined, etc.).

[PureDrive]

Thanks a lot bradgrafelman, that did it.