Re: Date problem
| From: | James Coates | Date: | Tue, 03 Dec 2002 14:42:05 +0000 |
| Subject: | Re: Date problem | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-126857@lists.php.net to get a copy of this message | ||
At 19:32 03/12/2002 +0800, Jason Wong wrote:
Assuming the column holding the the birthday is called 'birthday':[snip] Many thanks!
* give me actors whose birthdays fall between two dates (ie: Aries) This one is easy, use the BETWEEN clause in your SELECT statement. Consult manual for details.Ignoring the year, obviously, to get my Aries. :-) James. -- ------------------------------------------------------------------------------ jamesc@affection.net - http://www.affection.net/~jamesc/ - [+33] 6 79 02 08 99