[UPHPU] mysql date calculation bug

[Orson Jones]

Jim Anderson wrote:
> initial looks tells me that the following won't work either. run the
> following:
> 
> SELECT DATE_ADD('2007-02-28', INTERVAL 6 MONTH) + INTERVAL 49 DAY = CURDATE();
> SELECT DATE_ADD('2007-03-01', INTERVAL 6 MONTH) + INTERVAL 45 DAY = CURDATE();
> 
> those 2 queries both return true. notice, though, that they are 1
> calendar day apart and 4 interval days apart. this is going to have the
> same basic effect as before. :(

I don't think that would have the same problem. (4 emails sent.) I believe it
would actually send only 1 email. (You might have a few days interlude that no
emails are sent to anyone, but never four emails in a row.)

Orson