On 10/15/07, Jim Anderson <[EMAIL PROTECTED]> wrote:
>
> SELECT DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 44 DAY), INTERVAL 6 MONTH);
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
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
