Postgres Pro
Downloads
Home   >   mailing lists

Thread: sorting by date & time in descending order ??

sorting by date & time in descending order ??

From
Ralf Weidemann
Date:
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
);

Re: [GENERAL] sorting by date & time in descending order ??

From
Kollar Lajos
Date:

On Tue, 30 Mar 1999, Ralf Weidemann wrote:

> 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 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)
>
this orders creationdate asc and creationtime desc as the output also shows,
so try:

select surname, creationdate, creationtime
  from message order by creationdate desc, creationtime desc;

this should work.

            Lajos

Re: [GENERAL] sorting by date & time in descending order ??

From
Bob Dusek
Date:
Hi Ralph,

Did you try:

select surname, creationdate, creationtime from message order by
creationdate desc, creationtime desc;

??

It appears that all of your other queries are working as expected.

Bob

Ralf Weidemann wrote:
>
> 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
> );