Hi,
Try here
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Penduga Arus [mailto:[EMAIL PROTECTED]
Sent: Monday, 31 July 2006 9:03 PM
To: mysql@lists.mysql.com
Subject: select between date
I want to do a program to display birthday for our staff. I have a
field named birthday with date format (yyyy-mm-dd), from this field I
want to display the staff who will have their birthday start from
current date to 7 days a head.
please help, thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
