MySQL 에서 INTERVAL 에 쓸 수 있는 것들

MySQL 날짜 함수 같은데서 INTERVAL unit 으로 쓸 수 있는 것들

unit value	Expected expr Format
MICROSECOND	MICROSECONDS
SECOND	SECONDS
MINUTE	MINUTES
HOUR	HOURS
DAY	DAYS
WEEK	WEEKS
MONTH	MONTHS
QUARTER	QUARTERS
YEAR	YEARS
SECOND_MICROSECOND	'SECONDS.MICROSECONDS'
MINUTE_MICROSECOND	'MINUTES:SECONDS.MICROSECONDS'
MINUTE_SECOND	'MINUTES:SECONDS'
HOUR_MICROSECOND	'HOURS:MINUTES:SECONDS.MICROSECONDS'
HOUR_SECOND	'HOURS:MINUTES:SECONDS'
HOUR_MINUTE	'HOURS:MINUTES'
DAY_MICROSECOND	'DAYS HOURS:MINUTES:SECONDS.MICROSECONDS'
DAY_SECOND	'DAYS HOURS:MINUTES:SECONDS'
DAY_MINUTE	'DAYS HOURS:MINUTES'
DAY_HOUR	'DAYS HOURS'
YEAR_MONTH	'YEARS-MONTHS'

 

SELECT DATE_SUB(NOW(), INTERVAL 1 MONTH); 

 

 

mysql> SELECT DATE_ADD('1999-12-31 23:59:59.0000002', INTERVAL '1.999999' SECOND_MICROSECOND);
+---------------------------------------------------------------------------------+
| DATE_ADD('1999-12-31 23:59:59.0000002', INTERVAL '1.999999' SECOND_MICROSECOND) |
+---------------------------------------------------------------------------------+
| 2000-01-01 00:00:00.999999                                                      |
+---------------------------------------------------------------------------------+
1 row in set (0.00 sec)