o:[EMAIL PROTECTED]]
Gesendet: Dienstag, 23. August 2005 21:37
An: mysql@lists.mysql.com
Betreff: Date arithmetic: 2005-08-31 - 1
All,
I know MySQL comes with all sorts of wonderful functions to do date
arithmetic, the problem is the context that my application is being
called in I don't know
[EMAIL PROTECTED] wrote:
You are right. There are a lot of date functions in MySQL. However, I am
not sure exactly what your needs are...
I think you are trying to compute date intervals (did you NOT see the
INTERVAL keyword when you RTFM?). Most of the date functions currently
supported a
Barbara Deaton wrote:
> All,
>
> I know MySQL comes with all sorts of wonderful functions to do date
> arithmetic, the problem is the context that my application is being
> called in I don't know if a user wants me to add or subtract days. I'm
> just given the number of days that need to be eithe
Tuesday, August 23, 2005 3:45 PM
To: Barbara Deaton; mysql@lists.mysql.com
Subject: AW: Date arithmetic: 2005-08-31 - 1
Barbara,
Can't you use the ADDDATE function ?
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
Freddie
> -Ursprüngliche Nachricht-
> Von: Barba
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 08/23/2005 03:36:52 PM:
> All,
>
> I know MySQL comes with all sorts of wonderful functions to do date
> arithmetic, the problem is the context that my application is being
> called in I don't know if a user wants me to add or subtract days.
> I'm
+
1 row in set (0.00 sec)
mysql> select now()
-> ;
+-+
| now() |
+-+
| 2005-08-23 15:38:31 |
+-+
1 row in set (0.00 sec)
-Original Message-
From: Barbara Deaton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 23
m
> Betreff: Date arithmetic: 2005-08-31 - 1
>
> All,
>
> I know MySQL comes with all sorts of wonderful functions to
> do date arithmetic, the problem is the context that my
> application is being called in I don't know if a user wants
> me to add or subtract days.
All,
I know MySQL comes with all sorts of wonderful functions to do date arithmetic,
the problem is the context that my application is being called in I don't know
if a user wants me to add or subtract days. I'm just given the number of days
that need to be either added or subtracted from the
