1. DATE_ADD
- 시간/기간 더하기 함수
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT NOW() AS NOW,
DATE_ADD(NOW(), INTERVAL 1 SECOND) AS NOW_SECOND,
DATE_ADD(NOW(), INTERVAL 1 MINUTE) AS NOW_MINUTE,
DATE_ADD(NOW(), INTERVAL 1 HOUR) AS NOW_HOUR,
DATE_ADD(NOW(), INTERVAL 1 DAY) AS NOW_DAY,
DATE_ADD(NOW(), INTERVAL 1 MONTH) AS NOW_MONTH,
DATE_ADD(NOW(), INTERVAL 1 YEAR) AS NOW_YEAR
UNION
SELECT NOW() AS NOW,
DATE_ADD(NOW(), INTERVAL -1 SECOND) AS NOW_SECOND,
DATE_ADD(NOW(), INTERVAL -1 MINUTE) AS NOW_MINUTE,
DATE_ADD(NOW(), INTERVAL -1 HOUR) AS NOW_HOUR,
DATE_ADD(NOW(), INTERVAL -1 DAY) AS NOW_DAY,
DATE_ADD(NOW(), INTERVAL -1 MONTH) AS NOW_MONTH,
DATE_ADD(NOW(), INTERVAL -1 YEAR) AS NOW_YEAR
|
2. DATE_SUB
- 시간/기간 빼기 함수
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT NOW() AS NOW,
DATE_SUB(NOW(), INTERVAL 1 SECOND) AS NOW_SECOND,
DATE_SUB(NOW(), INTERVAL 1 MINUTE) AS NOW_MINUTE,
DATE_SUB(NOW(), INTERVAL 1 HOUR) AS NOW_HOUR,
DATE_SUB(NOW(), INTERVAL 1 DAY) AS NOW_DAY,
DATE_SUB(NOW(), INTERVAL 1 MONTH) AS NOW_MONTH,
DATE_SUB(NOW(), INTERVAL 1 YEAR) AS NOW_YEAR
UNION
SELECT NOW() AS NOW,
DATE_SUB(NOW(), INTERVAL -1 SECOND) AS NOW_SECOND,
DATE_SUB(NOW(), INTERVAL -1 MINUTE) AS NOW_MINUTE,
DATE_SUB(NOW(), INTERVAL -1 HOUR) AS NOW_HOUR,
DATE_SUB(NOW(), INTERVAL -1 DAY) AS NOW_DAY,
DATE_SUB(NOW(), INTERVAL -1 MONTH) AS NOW_MONTH,
DATE_SUB(NOW(), INTERVAL -1 YEAR) AS NOW_YEAR
|