Обсуждение: Sorting dates

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,

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.

Peter Eisentraut <peter_e@gmx.net> writes:
> 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

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

I'd bet a good deal that the "date" column isn't a datetime type at all,
but text or varchar.

            regards, tom lane

On Friday 15 May 2009 09:16:33 Peter Eisentraut wrote:
> 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
....
> This report would make a lot more sense if you posted your schema
> definition.

And the used query, I've been unable to make a seleLct order meaningfully.

F.O.S.