Peter
>Is there any function in MySQL that adds days to a date?
See ADDDATE(...) at
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
PB
-
Peter Lauri wrote:
Best group member,
I have a field called
expiredate of type ‘date’.
I would like to add
You could use something like
from_unixtime(to_unixtime(dateField)+(86400*17))
I store dates in unix timestamp format in bigints whenever possible for
this very reason.
=C=
Peter Lauri wrote:
Best group member,
I have a field called expiredate of type ‘date’. I would like to add 17
days
SELECT DATE_ADD(expiredate, INTERVAL 17 DAYS)
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
""Peter Lauri"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Best group member,
I have a field called expiredate of type 'date'. I would like to add 17 days
to the ex
Simply:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Just check the DATE_ADD part.
On 11/30/05, Peter Lauri <[EMAIL PROTECTED]> wrote:
>
>
>
> Best group member,
>
>
>
> I have a field called expiredate of type 'date'. I would like to add 17 days
> to the expiredate withou
