List:General Discussion« Previous MessageNext Message »
From:Peter Hicks Date:April 26 1999 10:50pm
Subject:Order by date
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Folks,

I have the following SQL statement:

   SELECT * FROM members WHERE date_of_birth != '0000-00-
00' ORDER BY date_of_birth;

date_of_birth is a DATE field, and I want to sort the results of the 
query on the month and day - to extract a list of birthdays 
throughout the year, in order, ignoring the year of birth.

Can anyone help?



-----BEGIN PGP SIGNATURE-----
Version: PGP 6.0.2 -- QDPGP 2.60 

iQA/AwUBNyTtxyNeTDpbBy8EEQLq5QCgh9XgBG2YKLxWK3gH/VHWE+2OeYgAoK7Z
DAjOFM6kkRywE53CqBxP6KPF
=xu+x
-----END PGP SIGNATURE-----

---
Peter Hicks
Network Engineer
peter <DOT> hicks (AT) poggs.co.uk
Thread
Order by datePeter Hicks27 Apr
  • Re: Order by dateChristian Mack27 Apr
Re: Order by dateFred Lindberg27 Apr