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