Re: cycled order

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 27 May 1999 13:43:38 -0400
Message-ID: <7ik79m$7hv$5@autumn.news.rcn.net>

Hi Fred,

Here's a really ugly answer.

        SELECT my_date
        FROM my_table
        ORDER BY TO_CHAR(my_date,'YYYY-MM-DD');

regards

Jerry Gitomer

Fred Ruffet wrote in message <7ijr8h$fr4$1_at_gatekeeper.ornano.kapt.com>...
>Hi everyone,
>
>Here's a little problem. I have a table T with a key K, a name N and a
>birthdate D. I would like to do a select that would give me the list of all
>people ordered by birthdate in the year (I mean that 2-jan-1960 is after
>1-jan-1960, and also after 1-jan-1970). This list would begin on the
today's
>date.
>
>if I have this list :
>
>01-sep-1960
>15-aug-1964
>17-jan-1968
>23-may-1974
>24-nov-1974
>
>and we are the 27 april, it would return :
>
>15-aug-1964
>01-sep-1960
>24-nov-1974
>17-jan-1968
>23-may-1974
>
>Pretty, isn't it ?
>Thanks for any help,
>
>Fred
>
>"It's not because you're paranoid that they're not after you."
>
>
Received on Thu May 27 1999 - 12:43:38 CDT