sorting by date & time in descending order ??

Started by Ralf Weidemannabout 27 years ago1 messagesgeneral

RalfW@Scalar.DE

about 27 years ago

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
);