Hi,

If you have used a timestamp/date data type in the MySQL or RDB you can also do ORDER BY, because the RDB will support this function.

But if you used a varchar or a text type, then you must do sorting outside the DB, fetching all values into a data type in perl and doing a "custom" sort.

I don't know of any RDBMS which not support sorting of one of his time/date data types. And on most of them you have also functions or setting to say which format you will get when you retrieve the data, that has nothing to do with the sorting that the RDBMS will do.

Regards,

|fire| at irc