w3resource

MySQL UTC_TIME() function

UTC_TIME() function

MySQL UTC_TIME returns the current UTC time as a value in 'HH:MM:SS' or HHMMSS format depending on the context of the function i.e. in a string or numeric context.

Syntax:

UTC_TIME; UTC_TIME()

Syntax Diagram: 1

MySQL UTC_TIME() Function - Syntax Diagram

Syntax Diagram: 2

MySQL UTC_TIME() Function - Syntax Diagram

MySQL Version: 5.6


Video Presentation:

Pictorial Presentation:

Pictorial Presentation of MySQL UTC_TIME() function

Example: MySQL UTC_TIME() function

The following statement will return the current UTC time.

Code:

SELECT UTC_TIME,UTC_TIME();

Sample Output:

mysql> SELECT UTC_TIME,UTC_TIME();
+----------+------------+
| UTC_TIME | UTC_TIME() |
+----------+------------+
| 22:26:15 | 22:26:15   | 
+----------+------------+
1 row in set (0.02 sec)

Note: The above output shows the UTC time at the time of execution of the command. Values of the output of the code bellow may be different, since it will show the of UTC time of when you click View the example in browser.

PHP script:

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>example-utc_time-function - php mysql examples | w3resource</title>
<meta name="description" content="example-utc_time-function - php mysql examples | w3resource">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<h2>Current UTC time in two different ways:</h2>
<table class='table table-bordered'>
<tr>
<th>Current UTC time using UTC_TIME</th><th>Current UTC time using UTC_TIME()</th>
</tr>
<?php
$hostname="your_hostname";
$username="your_username";
$password="your_password";
$db = "your_dbname";
$dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
foreach($dbh->query('SELECT UTC_TIME,UTC_TIME()') as $row) {
echo "<tr>";
echo "<td>" . $row['UTC_TIME'] . "</td>";
echo "<td>" . $row['UTC_TIME()'] . "</td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
</div>
</body>
</html>

View the example in browser

JSP script:

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>example-utc_time-function</title>
</head>
<body>
<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
String Host = "jdbc:mysql://localhost:3306/w3resour_bookinfo";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
connection = DriverManager.getConnection(Host, "root", "datasoft123");
statement = connection.createStatement();
String Data ="SELECT UTC_TIME,UTC_TIME()";
rs = statement.executeQuery(Data);
%>
<TABLE border="1">
<tr width="10" bgcolor="#9979">
<td>Current UTC time using UTC_TIME</td>
<td>Current UTC time using UTC_TIME()</td>
</tr>
<%
while (rs.next()) {
%>
<TR>
<TD><%=rs.getString("UTC_TIME")%></TD>
<TD><%=rs.getString("UTC_TIME()")%></TD>
</TR>
<%   }    %>
</table>
<%
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
out.println("Can’t connect to database.");
}
%>
</body>
</html>

Example of MySQL UTC_TIME() function in numeric format

The following statement will return the current UTC time in numeric format.

SELECT UTC_TIME()+0;

Sample Output:

mysql> SELECT UTC_TIME()+0;
+---------------+
| UTC_TIME()+0  |
+---------------+
| 222924.000000 | 
+---------------+
1 row in set (0.01 sec)

PHP script:

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>example1-utc_time-function - php mysql examples | w3resource</title>
<meta name="description" content="example1-utc_time-function - php mysql examples | w3resource">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<h2>Current UTC time in numeric format:</h2>
<table class='table table-bordered'>
<tr>
<th>Current UTC time in numeric format</th>
</tr>
<?php
$hostname="your_hostname";
$username="your_username";
$password="your_password";
$db = "your_dbname";
$dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
foreach($dbh->query('SELECT UTC_TIME()+0') as $row) {
echo "<tr>";
echo "<td>" . $row['UTC_TIME()+0'] . "</td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
</div>
</body>
</html>

View the example in browser

All Date and Time Functions:

Click here to see the MySQL Date and time functions.

Previous: UTC_DATE()
Next: UTC_TIMESTAMP()



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook