FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?

[Rene Fournier]

Okay, I realize that query won't work, but that's essentially want I  
want to do:

Add four months to the current date, then return the first day of that  
month, e.g.:

        floor ( 2008-10-16 + 4 months ) = 2009-02-1

Is there a nice SQL way of achieving this?

...Rene

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]