[UPHPU] mysql date calculation bug

[Jim Anderson]

> Just a suggestion related to the question...
>
> Try to use standard SQL if possible. Might help you in the future. I'm
> using two different standard forms for intervals here, plus the
> CURRENT_DATE standard SQL.
>
> SELECT (current_date - CAST('44 Days' as interval)) - interval '6 months'
>
> Looks cleaner to me, and it's not MySQL-specific.
>
> -Roberto
>   


not a bad idea. too bad your example doesn't execute for me ;)