웹이야기

MySQL CURRENT_TIMESTAMP, CURRENT_TIMESTAMP() 본문

D/MySQL

MySQL CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()

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

MySQL 날짜함수, 시간함수

 

CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()

 

 

CURRENT_TIMESTAMP

또는

CURRENT_TIMESTAMP([fsp])

의 형태

 

 

CURRENT_TIMESTAMP and CURRENT_TIMESTAMP() are synonym for NOW()

 

mysql> SELECT CURRENT_TIMESTAMP;
+---------------------+
| CURRENT_TIMESTAMP   |
+---------------------+
| 2020-04-01 14:46:56 |
+---------------------+
1 row in set (0.00 sec)

 

mysql> SELECT CURRENT_TIMESTAMP();
+---------------------+
| CURRENT_TIMESTAMP() |
+---------------------+
| 2020-04-01 14:47:06 |
+---------------------+
1 row in set (0.00 sec)

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

MySQL DATEDIFF()  (0) 2020.04.01
MySQL DATE()  (0) 2020.04.01
MySQL CURRENT_TIME, CURRENT_TIME()  (0) 2020.04.01
MySQL CURRENT_DATE, CURRENT_DATE()  (0) 2020.04.01
MySQL CURDATE()  (0) 2020.04.01
'D/MySQL' Related Articles more
Comments