Re: forcing date ordering - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: forcing date ordering
Date
Msg-id E18F88ED-03B3-11D9-9715-000A95C88220@myrealbox.com
Whole thread Raw
In response to forcing date ordering  ("tab view" <tabview@hotmail.com>)
List pgsql-novice
On Sep 6, 2004, at 10:21 PM, tab view wrote:

> SELECT DISTINCT to_char(datetimelogged,'dd/mm/yyyy') AS datelogged
> FROM logins ORDER BY datelogged DESC;
>
> I don't seem to get the column sorted in date order. How do I force
> psql to use date order?

What is the data type of the datetimelogged column?

Michael Glaesemann
grzm myrealbox com


pgsql-novice by date:

Previous
From: "Hari Bhanujan"
Date:
Subject: Re: pgsql functions and transactions?
Next
From: Oliver Elphick
Date:
Subject: Re: Installing language plpgsql