I am doing a simple query like col1, col2, date, col4 from table1.
All four colums are of type blob. For date column, I store a string
like this:
Fri Feb 13 11:01:24 2004
I store records as they come in so the oldest record is at the top of
the table. When I select and display, I want to display them in
reverse order (newest record at the top) but I can't sort on date with
strings like that.
Is there any way to do this w/o changing my column types or creating a
temporary table? I guess I can store all the rows temporarily in a
variable and print them out in reverse order but that's not an option.
I am looking a SQL way to accomplish this. Thanks.
-James