forcing date ordering

From: "tab view" <tabview(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: forcing date ordering
Date: 2004-09-06 13:21:24
Message-ID: BAY16-F4ZpieYqVBuuq0005d62a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When I do the following piece of SQL

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?

Nige

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ppp 2004-09-07 08:44:47 iso-8859-2
Previous Message Oliver Fromme 2004-09-06 10:26:16 Re: pgAccess via ssh?