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