[UPHPU] mysql date calculation bug

[Jim Anderson]

Orson Jones wrote:
> 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
>   
not sure. i also felt that was a potential threat and can afford to have 
to answer to the "why didn't these people get that email?" question. 
this solution just doesn't seem robust enough. :(

thnx,
-jim


> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>