DATE_ADD(기준날짜, INTERVAL)
SELECT DATE_ADD(NOW(), INTERVAL 1 SECOND)
SELECT DATE_ADD(NOW(), INTERVAL 1 MINUTE)
SELECT DATE_ADD(NOW(), INTERVAL 1 HOUR)
SELECT DATE_ADD(NOW(), INTERVAL 1 DAY)
SELECT DATE_ADD(NOW(), INTERVAL 1 MONTH)
SELECT DATE_ADD(NOW(), INTERVAL 1 YEAR)
SELECT DATE_ADD(NOW(), INTERVAL -1 YEAR)
DATE_SUB(기준날짜, INTERVAL)
SELECT DATE_SUB(NOW(), INTERVAL 1 SECOND)
반응형
'Database > MySQL' 카테고리의 다른 글
[MySQL] UNION, UNION ALL (0) | 2021.07.05 |
---|---|
[MySQL] JOIN (INNER JOIN, OUTER JOIN) (0) | 2021.07.05 |
[MySQL] DATE_FORMAT() (0) | 2021.07.02 |
[MySQL] NOW() 함수 (0) | 2021.03.30 |
[MySQL] MySQL 정의 (0) | 2021.03.23 |