How would I convert this varchar date field to a usable date format for queries?
Posted on 2008-06-10
I have a table which I need to be able to query by date. The date is stored as an email compliant RFC date, which looks like this:
Sun, 24 Feb 2008 02:38:57 -0500 (EST)
I need to be able to query against this table by time and date. So for instance, I need to know all the transaction id's that occurred between Feb 24 2008, between the times of 1:30pm and 2:30pm.
How would I do this with mysql? Changing the format of the date field is not an option.
Worth 500 points.