Re: forcing date ordering

#1

On Sep 6, 2004, at 10:21 PM, tab view wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

"tab view" <tabview (AT) hotmail (DOT) com> writes:

Quote:

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.

I'd expect that to produce a textual sorting of the to_char strings.

Quote:

How do I force psql to use date order?

Sort by the underlying datetimelogged column, which I suppose is of
date or timestamp type ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: forcing date ordering

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: forcing date ordering - 09-11-2004 , 01:31 AM

Re: forcing date ordering - 09-11-2004 , 02:22 AM