SQL sort question

[Ivan Smahin]

On Feb 26, 2013, at 5:42 PM, william humphrey <bill at bluewatermaritime.com> wrote:

> I have been using "ORDER BY" to sort a field which has dates in the format yyyy-mm-dd for years now and just today it sorts it like this (with "ORDER BY DESC):
> 
> 2006-02-15
> 2005-03-15
> 2013-01-24
> 2012-05-17
> 2012-05-10
> 
> What is going on?
> 
> I tested other sorts including recID and they work. Also that weird sort is not dependent on recID
> 
> The above should have sorted:
> 
> 2013-01-24
> 2012-05-17
> 2012-05-10
> 2006-02-15
> 2005-03-15

What about database diagnose and reindex in case of problems?

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130226/9bde5ab4/attachment.html>