DATETIME MySQL - using only month and date
| From: | information@alternity.biz | Date: | Sat, 09 Apr 2005 12:46:41 +0000 |
| Subject: | DATETIME MySQL - using only month and date | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39160@lists.php.net to get a copy of this message | ||
Good day to all of you
---
I have a recond in my Database that is called closing and it is a DATETIME ( YYYY-MM-DD HH:MM:SS )
I would like to be able to SELECT from the DB a range of information
e.x. FROM 15/02 to 17/03
Can you please tell me how the SQL query should be constructed it if
we suppose that:
$month_start : starting month
$month_end : ending month
$day_start : starting day
$day_end : ending day
---
Thank you very much in advance.