Our pleasure. Good day !!!
- Original Message -
From: Ed Curtis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: João Cândido de Souza Neto <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 12:48:29 PM GMT-0500 US/Eastern
Sub
Ed Curtis wrote:
UPDATE this_table SET
this_date = NOW(),
future_date = NOW() + INTERVAL 90 DAY;
This is probably along the lines of what you want..
Actually I'm setting the DATE via drop down menus using PHP and creating
the date by hand via variables. NOW() won't work in this instance.
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Oops, also the $this_date
>
> UPDATE this_table SET
> this_date = '$this_date',
> future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
Got it going guys, thanks again
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Neto <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 12:15:16 PM GMT-0500 US/Eastern
Subject: Re: date_add function
Please put the 2008-10-20 in single quotes
if you r are doing this in PHP
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD('$t
]>
Cc: João Cândido de Souza Neto <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 12:43:00 PM GMT-0500 US/Eastern
Subject: Re: date_add function
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Please check your syntax.
> It should look like this:
>
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Please check your syntax.
> It should look like this:
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
>
> Don't forget your WHERE clause or else you populate every row.
Tried it, this is what
On Wed, 11 Oct 2006, Mark Leith wrote:
> Ed Curtis wrote:
> > I'm having some trouble setting a future date within a table. I have one
> > column 'this_date' which is a DATE field and I'm trying to add 90 days to
> > it and set a column named 'future_date', also a DATE field.
> >
> > I don't kno
ROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 11:50:17 AM GMT-0500 US/Eastern
Subject: Re: date_add function
Why you don�t try this?
UPDATE this_table SET
this_date = $this_date,
future_date = (DATE_ADD($this_date) INTERVAL 90 DAY)
"Ed Curtis" <[EMAIL
Your sql has more error.
I´ll put the right way below.
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD($this_date, INTERVAL 90 DAY)
It´ll works fine.
""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> escreveu na
mensagem news:[EMAIL PROTECTED]
> Why you don´t try th
Why you don´t try this?
UPDATE this_table SET
this_date = $this_date,
future_date = (DATE_ADD($this_date) INTERVAL 90 DAY)
"Ed Curtis" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
>
> I'm having some trouble setting a future date within a table. I have one
> column 'this_da
Ed Curtis wrote:
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
t
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
the 'this_date' and
Hi
I hope I am not being lazy here. I want to use the SQL date_add
function on a value from one of my column values but I can't seem to
figure out the syntax.
This works:
select "2002-10-08 09:35:10" + interval 7 hour;
but how do I change "2002-10-08 09:35:10" to
13 matches
Mail list logo