[PHP-DB] DATETIME MySQL - using only month and date

2005-04-10 Thread [EMAIL PROTECTED]
Good day to all of you --- I have a recond in my Database that is called closing and it is a DATETIME ( -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

Re: [PHP-DB] DATETIME MySQL - using only month and date

2005-04-10 Thread Andrés G . Montañez
$month_start : starting month $month_end : ending month $day_start : starting day $day_end : ending day You could add something like this in the WHERE clause: ((MONTH(closing) = $month_start AND DAY(closing) = $day_start) AND (MONTH(closing) = $month_end AND DAY(closing) = $day_end)) --