[SOLVED] Get MySQL to parse dates
Posted: Fri Feb 11, 2005 3:06 pm
I had previously ordered by timestamp, which worked until I realized that updating a record also changed the timestamp.
So I have to fall back to ordering by date of insertion, which is stored as:
Thursday 10th of February 2005 10:52:54 AM
However, these are stored as VARCHAR, which I did very early on -- a mistake, I know!
I'd like to order by them on retrieval.
Is there any way to get mysql to do the parsing instead of PHP?
So I have to fall back to ordering by date of insertion, which is stored as:
Thursday 10th of February 2005 10:52:54 AM
However, these are stored as VARCHAR, which I did very early on -- a mistake, I know!
I'd like to order by them on retrieval.
Is there any way to get mysql to do the parsing instead of PHP?