Chris,
>would someone mind giving me a example query
>where I would add 21 days to a datetime field
Mysql, query
mysql> create table member (
-> dt datetime );
Query OK, 0 rows affected (0.09 sec)
mysql> insert into member values ('1991-06-22 14:00:00');
Query OK, 1 row affected (0.05 sec)
mysql> select DATE_ADD(dt, INTERVAL 21 DAY) from member;
+-------------------------------+
| DATE_ADD(dt, INTERVAL 21 DAY) |
+-------------------------------+
| 1991-07-13 14:00:00 |
+-------------------------------+
1 row in set (0.00 sec)
Bruce MacDonald
Minnesota Public Radio
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
