From: | Michael Agbaglo <byteshifter(at)shifted-bytes(dot)de> |
---|---|
To: | josh(at)agliodbs(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: how to sort a birthday list ? |
Date: | 2002-06-21 08:30:54 |
Message-ID: | 3D12E43E.3090307@shifted-bytes.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Dear Josh,
if you sort by AGE then the order will be young -> old or vice versa.
I'd like to have the list sorted as interval birthDAY, birthMONTH and
DAY from NOW() and MONTH from NOW().
example:
22.06.64 Person-1
26.06.50 Person-2
01.08.69 Person-3
02.08.71 Person-4
...
of course you could sort by DOY but then you'll have a problem w/ the
next year:
if it's let's say december and you select the list for the next 60 days,
persons having birthday in december will appear after persons having
birthday in january.
I tried to use CASE WHEN... THEN in ORDER BY but it doesn't seem to work
(syntax error at '')
M.
Josh Berkus wrote:
> Michael,
>
>
>>SELECT *
>>FROM Persons
>>WHERE EXTRACT( YEAR FROM AGE(dateofbirth) ) < EXTRACT( YEAR FROM AGE(
>>CURRENT_DATE+60, dateofbirth ) )
>>
>>... but how do I sort the list ?
>>
>
> Easy:
>
> SELECT person_name, person_department, EXTRACT( YEAR FROM AGE(dateofbirth) )
> as their_age
> FROM Persons
> WHERE EXTRACT( YEAR FROM AGE(dateofbirth) ) < EXTRACT( YEAR FROM AGE(
> CURRENT_DATE+60, dateofbirth ) )
> ORDER BY their_age, person_name
>
> As an example.
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Agbaglo | 2002-06-21 09:23:04 | Re: how to sort a birthday list ? |
Previous Message | Cliff Wells | 2002-06-21 07:43:43 | Re: skip weekends |