MySQL UTC_TIME()

MySQL 날짜함수, 시간함수

 

UTC_TIME()

   -

 

UTC_TIME, UTC_TIME([fsp])

의 형태

 

Returns the current UTC time as a value 'hh:mm:ss' or hhmmss format, depending on whether the function is used in string or numeric context.

 

If the fsp argument is given to sepcify a fractional seconds precision form 0 to 6, the return value includes a fractional seconds part of that many digits.

 

mysql> SELECT UTC_TIME(), UTC_TIME+0 ;
+------------+------------+
| UTC_TIME() | UTC_TIME+0 |
+------------+------------+
| 03:45:22   |      34522 |
+------------+------------+
1 row in set (0.00 sec)

 

mysql> SELECT UTC_TIME(3) ;
+--------------+
| UTC_TIME(3)  |
+--------------+
| 03:45:40.858 |
+--------------+
1 row in set (0.00 sec)