MySQL DATE()

MySQL 날짜함수, 시간함수

 

DATE()

   - 날짜를 추출

 

 

DATE(expr)

의 형태로 사용

 

Extract the date part of the date or datetime expression expr.

 

 

mysql> SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
+-----------------------------+
| 2003-12-31                  |
+-----------------------------+
1 row in set (0.00 sec)

 

mysql> SELECT DATE(NOW());
+-------------+
| DATE(NOW()) |
+-------------+
| 2020-04-01  |
+-------------+
1 row in set (0.00 sec)