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)