웹이야기

MySQL UTC_TIMESTAMP() 본문

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)

 

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

MySQL WEEKDAY()  (0) 2020.04.05
MySQL WEEK()  (0) 2020.04.05
MySQL UTC_TIME()  (0) 2020.04.05
MySQL UTC_DATE()  (0) 2020.04.05
MySQL UNIX_TIMESTAMP()  (0) 2020.04.05
Comments