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 ;) _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
