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

In MySQL<\/a>, you can use the UTC_DATE<\/code> function to return the UTC date. 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 ‘YYYY-MM-DD’<\/em> or YYYYMMDD<\/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_DATE\r\nUTC_DATE()\r\n<\/pre>\n
So no arguments are required.<\/p>\n
Example 1 – Basic Usage<\/h2>\n
Here’s an example to demonstrate.<\/p>\n
SELECT UTC_DATE;\r\n<\/pre>\n
Result:<\/p>\n
+------------+\r\n| UTC_DATE   |\r\n+------------+\r\n| 2018-07-05 |\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_DATE();\r\n<\/pre>\n
Result:<\/p>\n
+------------+\r\n| UTC_DATE() |\r\n+------------+\r\n| 2018-07-05 |\r\n+------------+\r\n<\/pre>\n
Example 3 – Numerical Context<\/h2>\n
The previous examples were all returned in ‘YYYY-MM-DD’<\/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_DATE() + 0;\r\n<\/pre>\n
Result:<\/p>\n
+----------------+\r\n| UTC_DATE() + 0 |\r\n+----------------+\r\n|       20180705 |\r\n+----------------+\r\n<\/pre>\n
In this case I added zero, which kept the date the same. However, the result is\u00a0now in\u00a0YYYYMMDD<\/em> format.<\/p>\n
There’s nothing to stop you from adding another number. Example:<\/p>\n
SELECT UTC_DATE() + 5;\r\n<\/pre>\n
Result:<\/p>\n
+----------------+\r\n| UTC_DATE() + 5 |\r\n+----------------+\r\n|       20180710 |\r\n+----------------+\r\n<\/pre>\n
Also see UTC_TIME<\/code> Examples<\/a> for returning the UTC time.<\/p>\n","protected":false},"excerpt":{"rendered":"
In MySQL, you can use the UTC_DATE function to return the UTC date. 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 ‘YYYY-MM-DD’ or YYYYMMDD 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-2884","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\/2884","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=2884"}],"version-history":[{"count":3,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/2884\/revisions"}],"predecessor-version":[{"id":2889,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/2884\/revisions\/2889"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=2884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=2884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=2884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}