sorting by date & time in descending order ?? - Mailing list pgsql-general

Hi all,

I want to sort my output by date & time in descending
order. How can I do this ? Date or time alone is not
enough and the combination of both does not work. At
least in the way I tried it..

Thanks,
Ralf


wdb=> select surname, creationdate, creationtime
       from message order by creationtime desc;
surname             |creationdate|creationtime
--------------------+------------+------------
Name_1              |  30.03.1999|14:46:17
Name_2              |  30.03.1999|14:05:47
Name_2              |  30.03.1999|10:10:04
Name_2              |  29.03.1999|09:10:04
Name_2              |  30.03.1999|09:10:04
Name_3              |  22.03.1999|06:02:55
(6 rows)

wdb=> select surname, creationdate, creationtime
       from message order by creationdate desc;
surname             |creationdate|creationtime
--------------------+------------+------------
Name_2              |  30.03.1999|14:05:47
Name_2              |  30.03.1999|10:10:04
Name_1              |  30.03.1999|14:46:17
Name_2              |  30.03.1999|09:10:04
Name_2              |  29.03.1999|09:10:04
Name_3              |  22.03.1999|06:02:55
(6 rows)

wdb=> select surname, creationdate, creationtime
       from message order by creationdate, creationtime desc;
surname             |creationdate|creationtime
--------------------+------------+------------
Name_3              |  22.03.1999|06:02:55
Name_2              |  29.03.1999|09:10:04
Name_1              |  30.03.1999|14:46:17
Name_2              |  30.03.1999|14:05:47
Name_2              |  30.03.1999|10:10:04
Name_2              |  30.03.1999|09:10:04
(6 rows)


CREATE TABLE  Message
(
    MessageID            SMALLINT    NOT NULL,
    Title                CHAR(20)    NOT NULL,
    Surname                CHAR(50)    NOT NULL,
    EMail                CHAR(100),
    MessageURL            CHAR(100),
    Text                VARCHAR        NOT NULL,
    CreationDate        DATE        NOT NULL,
    CreationTime        TIME        NOT NULL,
    Expiry                SMALLINT    NOT NULL
);