Sorting dates

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.