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
On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier [EMAIL PROTECTED] wrote:
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
In the last episode (Oct 17), Rene Fournier said:
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
Since you know the
2008/10/17 Rob Wultsch [EMAIL PROTECTED]:
On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier [EMAIL PROTECTED] wrote:
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.:
On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian [EMAIL PROTECTED] wrote:
2008/10/17 Rob Wultsch [EMAIL PROTECTED]:
On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier [EMAIL PROTECTED]
wrote:
Okay, I realize that query won't work, but that's essentially want I
want
to do:
Add four months
On Fri, Oct 17, 2008 at 2:19 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian [EMAIL PROTECTED]wrote:
2008/10/17 Rob Wultsch [EMAIL PROTECTED]:
On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier [EMAIL PROTECTED]
wrote:
Okay, I realize that query