cycled order

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Thu, 27 May 1999 18:17:17 +0200
Message-ID: <7ijr8h$fr4$1@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 - 11:17:17 CDT