Re: Sorting dates

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Hershel Fisch <hershrev(at)syp2u4c(dot)com>
Subject: Re: Sorting dates
Date: 2009-05-15 07:16:33
Message-ID: 200905151016.33986.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Friday 15 May 2009 01:07:11 Hershel Fisch wrote:
> 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,

This report would make a lot more sense if you posted your schema definition.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Johansson 2009-05-15 09:03:14 Re: Is this the expected behaviour for DDL-query execution?
Previous Message Hershel Fisch 2009-05-14 22:07:11 Sorting dates