RE: How to check that today's date is within a given range

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I have a start_date and a finish_date stored in a mysql db.
> 
> I want to check that today's date falls between these 2 dates.
> 
> Can I set up the 3 dates so that a simple subtraction can be done? eg
> 
> if (($today - $start > 0) && ($finish - $today >0)) {
>  ...within range...
> } else {
>  ...out of range...
> }
> 
> I can't seem to find date functions that are of any use for this.

I could have sworn I already answered this today...

SELECT ... FROM table WHERE CURDATE() BETWEEN start AND end

Where 'start' and 'end' are your columns...

It's slightly faster to use CURDATE() > start AND CURDATE < end, but I
find BETWEEN easier to read...

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux