List:General Discussion« Previous MessageNext Message »
From:Néstor Date:December 6 2006 1:32am
Subject:Converting a field or converting a date?
View as plain text  
People,

I am not very savy with SQL and I need help.  I have a char field
that contains a date and the date is in DD-MM-YYYY  and I want to
sort it but the sort is wrong because 01-04-2007 comes out before
10-22-2006.

Is there an easy way to provide a correct sorted output list or do I
need to edit my table and convert all my fields to YYYY-MM-DD
before I can sort it.

Any help is welcome.

Thanks,

Néstor :-)

Thread
Converting a field or converting a date?Néstor6 Dec
  • Re: Converting a field or converting a date?Dan Nelson6 Dec