-----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
