D/MySQL
MySQL UTC_TIMESTAMP()
yeon.Biju
2020. 4. 5. 12:50
MySQL 날짜함수, 시간함수
UTC_TIMESTAMP()
-
UTC_TIMESTAMP, UTC_TIMESTAMP()
의 형태
Returns the current UTC date and time as a value in 'YYYY-MM-DD hh:mm:ss' or YYYYMMDDHHmmss format, depending on whether the function is used in string or numeric context,
If the fsp argument is given to sepcifiy a fractional seconds parcision from 0 to 6, the return value includes a fractional seconds part of that many digits.
mysql> SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP()+0;
+---------------------+-------------------+
| UTC_TIMESTAMP() | UTC_TIMESTAMP()+0 |
+---------------------+-------------------+
| 2020-04-05 03:49:47 | 20200405034947 |
+---------------------+-------------------+
1 row in set (0.00 sec)