CURTIME,CURRENT_TIME

Description

Retrieves the current time and returns it as a TIME type.

This function is consistent with the curtime function in MySQL.

Aliases

• CURRENT_TIME

Syntax

CURTIME([<precision>])

Parameters

Parameter	Description
<precision>	Optional parameter indicating the precision of the fractional seconds part of the return value, must be a constant value ranging from 0 to 6. Default is 0, which means no fractional seconds part is returned.

Return Value

Returns the current time type of TIME.

Examples

mysql> select curtime();

+----------------+
| curtime()      |
+----------------+
| 15:25:47       |
+----------------+

mysql> select curtime(0);
+------------+
| curtime(0) |
+------------+
| 13:15:27   |
+------------+

mysql> select curtime(4);
+---------------+
| curtime(4)    |
+---------------+
| 15:31:03.8958 |
+---------------+

mysql> select curtime(7);
ERROR 1105 (HY000): errCode = 2, detailMessage = The precision must be between 0 and 6