C:\Users\zany>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.32-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select now() as today;
+---------------------+
| today |
+---------------------+
| 2009-04-30 11:49:00 |
+---------------------+
1 row in set (0.00 sec)
mysql> select date_add(now(), interval -1 day) as yesterday;
+---------------------+
| yesterday |
+---------------------+
| 2009-04-29 11:49:00 |
+---------------------+
1 row in set (0.00 sec)
mysql> select date_add(now(), interval 1 day) as tomorrow;
+---------------------+
| tomorrow |
+---------------------+
| 2009-05-01 11:49:00 |
+---------------------+
1 row in set (0.00 sec)
mysql> select date_add(now(), interval 1 month) as `1 month ago`;
+---------------------+
| 1 month ago |
+---------------------+
| 2009-05-30 11:49:00 |
+---------------------+
1 row in set (0.00 sec)
mysql> select date_add(now(), interval 1 year) as`1 year ago`;
+---------------------+
| 1 year ago |
+---------------------+
| 2010-04-30 11:49:00 |
+---------------------+
1 row in set (0.00 sec)
mysql>
날짜 연산은 이렇게 하면 되겠다.
date_sub 도 있는데, date_add 랑 완전 동일하고 날짜를 빼는데만 사용된다.
걍 date_add 로 통일하고 양수,음수값을 주는 걸로 해결하면 되겠다.
EOF : Zany (2009-04-30)
|
|
|
