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)