Date Sort

[natalieG]

I have a date column that I plan to store as a string, ie 'jan 12,1996' I want order by that
column. Can this be done. or should add a column to store the secondsfromEpoch in the second column
and get the date strin g when I need it.

Thanks,

Jennifer Good

[.josh]

if you store the date in a column of data type date or datetime or timestamp or even as a number datatype (holding the unix timestamp) then you can sort by that column. but if you store the date as a regular string datatype, like varchar, blob, whatever, then it will just sort it alphabetically.