Re: forcing date ordering

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "tab view" <tabview(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: forcing date ordering
Date: 2004-09-11 05:31:50
Message-ID: E18F88ED-03B3-11D9-9715-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2004-09-11 05:55:03 Re: Installing language plpgsql
Previous Message Tim Pushor 2004-09-10 18:15:19 Re: how to overwrite tuples in a table