MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References

MariaDB UTC_TIME() Function



The MariaDB UTC_TIME() function returns the current UTC time. It returns the current time in the following format:

  • Returns the current time as a 'HH:MM:SS' format, if used in a string context.
  • Returns the current time as a HHMMSS.uuuuuu format, if used in a numeric context.

Syntax

UTC_TIME()

Parameters

No parameter is required.

Return Value

Returns the current UTC time.

Example 1:

The example below shows the usage of UTC_TIME() function.

SELECT UTC_TIME();
Result: '10:51:38'

SELECT UTC_TIME() + 0;
Result: 105138

SELECT UTC_TIME() + 1;
Result: 105139

Example 2:

Consider a database table called EmployeeLogin with the following records:

EmpIDNameDateLogin Time
1John2019-10-2509:20:38
2Marry2019-10-2509:21:05
3Jo2019-10-2509:24:35
4Kim2019-10-2509:25:24
5Ramesh2019-10-2509:27:16

To insert a new record in this table, the following query can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', UTC_DATE(), UTC_TIME());

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to:

EmpIDNameDateLogin Time
1John2019-10-2509:20:38
2Marry2019-10-2509:21:05
3Jo2019-10-2509:24:35
4Kim2019-10-2509:25:24
5Ramesh2019-10-2509:27:16
6Suresh2019-10-2509:28:19

❮ MariaDB Functions

5