Sorting dates

From: Hershel Fisch <hershrev(at)syp2u4c(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Sorting dates
Date: 2009-05-14 22:07:11
Message-ID: C631E41F.13B%hershrev@syp2u4c.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi, I realized that sorting date is done like text and not numeric (dates)
e.g. SELELCT * FROM database_name ORDER BY date ASC

Return order

3/02/09
4/19/09
4/2/09

Thanks,

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2009-05-15 07:16:33 Re: Sorting dates
Previous Message Scott Mead 2009-05-14 21:20:50 Re: