{"id":2887,"date":"2018-07-05T15:42:00","date_gmt":"2018-07-05T22:42:00","guid":{"rendered":"https:\/\/database.guide\/?p=2887"},"modified":"2021-01-28T14:10:35","modified_gmt":"2021-01-28T04:10:35","slug":"utc_time-examples-mysql","status":"publish","type":"post","link":"https:\/\/database.guide\/utc_time-examples-mysql\/","title":{"rendered":"UTC_TIME Examples – MySQL"},"content":{"rendered":"

In MySQL<\/a>, you can use the UTC_TIME<\/code> function to return the UTC time. UTC stands for Coordinated Universal Time and it’s the primary time standard by which the world regulates clocks and time.<\/p>\n

The result is returned either in ‘HH:MM:SS’<\/em> or HHMMSS<\/em> format, depending on whether the function is used in a string or numeric context.<\/p>\n

<\/p>\n

Syntax<\/h2>\n

You can use either of the following two forms:<\/p>\n

UTC_TIME\r\nUTC_TIME([fsp])\r\n<\/pre>\n
Where fsp<\/code> is an optional argument that specifies the fractional seconds precision to use in the result.<\/p>\n
Example 1 – Basic Usage<\/h2>\n
Here’s an example to demonstrate.<\/p>\n
SELECT UTC_TIME;\r\n<\/pre>\n
Result:<\/p>\n
+----------+\r\n| UTC_TIME |\r\n+----------+\r\n| 22:38:38 |\r\n+----------+\r\n<\/pre>\n
Example 2 – With Parentheses<\/h2>\n
In this example I add the parentheses (of course, this makes no difference to the outcome).<\/p>\n
SELECT UTC_TIME();\r\n<\/pre>\n
Result:<\/p>\n
+------------+\r\n| UTC_TIME() |\r\n+------------+\r\n| 22:38:52   |\r\n+------------+\r\n<\/pre>\n
Example 3 – Fractional Seconds Precision<\/h2>\n
Here I add an argument that specifies the fractional seconds precision to use. In this case I use 6<\/code>, which means that the result will have a precision down to the millisecond.<\/p>\n
SELECT UTC_TIME(6);\r\n<\/pre>\n
Result:<\/p>\n
+-----------------+\r\n| UTC_TIME(6)     |\r\n+-----------------+\r\n| 22:45:19.912591 |\r\n+-----------------+\r\n<\/pre>\n
And in the next example I use 3<\/code> to reduce the fractional seconds precision:<\/p>\n
SELECT UTC_TIME(3);\r\n<\/pre>\n
Result:<\/p>\n
+--------------+\r\n| UTC_TIME(3)  |\r\n+--------------+\r\n| 22:45:55.415 |\r\n+--------------+\r\n<\/pre>\n
Example 4 – Numerical Context<\/h2>\n
The previous examples were all returned in ‘HH:MM:SS’<\/em> format. This is because they were used in a string context.<\/p>\n
In this example I use the function in a numerical context. I do this by adding a number to the function.<\/p>\n
SELECT UTC_TIME() + 0;\r\n<\/pre>\n
Result:<\/p>\n
+----------------+\r\n| UTC_TIME() + 0 |\r\n+----------------+\r\n|         223914 |\r\n+----------------+\r\n<\/pre>\n
In this case I added zero, so the result is\u00a0now in\u00a0HHMMSS<\/em> format.<\/p>\n
There’s nothing to stop you from adding another number. Example:<\/p>\n
SELECT \r\n  UTC_TIME() + 0,\r\n  UTC_TIME() + 5;\r\n<\/pre>\n
Result:<\/p>\n
+----------------+----------------+\r\n| UTC_TIME() + 0 | UTC_TIME() + 5 |\r\n+----------------+----------------+\r\n|         224051 |         224056 |\r\n+----------------+----------------+\r\n<\/pre>\n
Also see UTC_DATE<\/code> Examples<\/a> for returning the UTC date.<\/p>\n","protected":false},"excerpt":{"rendered":"
In MySQL, you can use the UTC_TIME function to return the UTC time. UTC stands for Coordinated Universal Time and it’s the primary time standard by which the world regulates clocks and time. The result is returned either in ‘HH:MM:SS’ or HHMMSS format, depending on whether the function is used in a string or numeric … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[68,115,93],"class_list":["post-2887","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-date-functions","tag-dates","tag-functions"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/2887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=2887"}],"version-history":[{"count":3,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/2887\/revisions"}],"predecessor-version":[{"id":2891,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/2887\/revisions\/2891"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=2887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=2887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=2887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}