Hi all:

Our company uses for reasons of experience, an INT(10) field for storing
dates in a MySQL DB. ((We just DO OK! ;-))
However I it is because the date isn't stored as a DATE or DATETIME
(etc) that I can't do an accurate ORDER BY <name_of_date_field> - as
MySQL doesn't recognise the field's content as a valid date simply an
integer (that we modify for display using PHP)

Does anyone know of a way (kludge or otherwise) I may be able to perform
such an ORDER BY, so that the dates in an HTML display table column are
ordered AS dates while using an INT field format??

Cheers folks.

Mr Russ Michell
Web Applications Developer

Tel: +61 (0)8 9321 3844 
Fax: +61 (0)8 6210 1364 
Post: PO Box 228, Innaloo, WA 6918, Australia 
Street: Suite 24, 158 William St, Perth, WA 6000, Australia

"No proof of existence is not proof of non-existence."
(Physicist: Stanton T. Friedman on Debunking Ufology)

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to