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

Syntax Diagram: 2

MySQL Version: 5.6
Video Presentation:
Pictorial Presentation:

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>
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>
All Date and Time Functions:
Click here to see the MySQL Date and time functions.
Previous: UTC_DATE()
Next: UTC_TIMESTAMP()
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
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