Posted by Rich on 09/27/16 11:45

On Tue, 18 Apr 2006 11:01:51 +0100, Mark D. Smith wrote...
>
>Hi
>
>i have some data which i can read ok but i need to display by date posted.
>Problem is the date is stored in a field as text DD/MM/YY
>
>using ORDER BY date_posted ASC does not give desired effect as it seems to
>use only the DD
>
>example of current output.
>
>05/04/06
>05/04/06
>05/04/06
>05/04/06
>16/01/06
>16/01/06
>22/03/06
>23/03/06
>24/03/06
>
>is there a way (otherthan re writing all the dates in database) to sort the
>dates by order ?
>
>Mark
>
>

If the date information was stored as "text" instead of a date type, I don't
think there's be an easy way to sort that. It will probably just do an
alphabetical sort. Not sure if "alter table" has any options to modify the
column type, but may simplify what you're trying to do.

Rich

--
Carry Forward Bandwidth! Included In All NewsGuy Accounts!
Don't lose what you don't use! - http://newsguy.com/overview.htm


--

[Back to original message]