웹이야기

MySQL DATE() 본문

D/MySQL

MySQL DATE()

yeon.Biju 2020. 4. 1. 14:55

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)


 

 

'D > MySQL' 카테고리의 다른 글

MySQL DATE_ADD(), DATE_SUB()  (0) 2020.04.01
MySQL DATEDIFF()  (0) 2020.04.01
MySQL CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()  (0) 2020.04.01
MySQL CURRENT_TIME, CURRENT_TIME()  (0) 2020.04.01
MySQL CURRENT_DATE, CURRENT_DATE()  (0) 2020.04.01
'D/MySQL' Related Articles more
Comments