UTC_TIME() - Current UTC Time

Q

How to obtain the current UTC time using the UTC_TIME() function?

✍: FYIcenter.com

A

UTC_TIME(prec) is a MySQL built-in function that returns the current UTC time. For example:

SELECT UTC_TIME(6), NOW(6), @@system_time_zone;
  -- +-----------------+----------------------------+--------------------+
  -- | UTC_TIME(6)     | NOW(6)                     | @@system_time_zone |
  -- +-----------------+----------------------------+--------------------+
  -- | 04:20:09.755859 | 2023-11-15 23:20:09.755859 | EST                |
  -- +-----------------+----------------------------+--------------------+

Reference information of the UTC_TIME() function:

UTC_TIME(prec): time
  Returns the current UTC time as a value in 'hh:mm:ss' or hhmmss
  format, depending on whether the function is used in string or numeric
  context.

Arguments, return value and availability:
  prec: Optional. Default is 0. The precision of fractional seconds.
  time: Return value. The current UTC time.
  Available since MySQL 4.

Related MySQL functions:

⇒ UTC_TIMESTAMP() - Current UTC Timestamp

⇐ UTC_DATE() - Current UTC Date

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1149🔥, 0💬

MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 1934🔥, 0💬

Calling MySQL Built-in Functions
Where to find answers to frequently asked questions about calling MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about calling MySQL Built-in Functions: Function Name Case Insensitive Function Argument Modifier Variable Number ... 2023-11-14, 1724🔥, 0💬

IS_UUID() - Validating UUID String Format
How to validate a UUID (Universal Unique IDentifier) string using the IS_UUID() function? IS_UUID(uuid) is a MySQL built-in function that validates a UUID (Universal Unique IDentifier) string. It only checks if the given UUID is a 32-digit hexadecimal string or not. For example: SELECT IS_UUID('447f... 2023-12-08, 1721🔥, 0💬

VARIANCE() - Synonym for VAR_POP()
What's the difference between VARIANCE() and VAR_POP() functions? VARIANCE(expr) is a synonym for the VAR_POP(expr) function. Related MySQL functions: VAR_POP() - Population Standard Variance ⇒ Window Functions ⇐ VAR_SAMP() - Sample Standard Variance ⇑ MySQL Functions on Aggregation Groups ⇑⇑ My... 2023-12-01, 1531🔥, 0💬

SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function? SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example: SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+-------- -+--------------------+-- | SQRT(2) | SQRT(4) | SQRT(... 2023-11-14, 1486🔥, 0💬

VAR_SAMP() - Sample Standard Variance
How to calculate the sample standard variance of a field expression in result set groups using the VAR_SAMP() function? VAR_SAMP(expr) is a MySQL built-in aggregate function that calculates the sample standard variance of a field expression in result set groups. For example: SELECT help_category_id,... 2023-12-01, 1464🔥, 0💬

YEARWEEK() - Year Week Combination
How to calculate the year week combination from a given date using the YEARWEEK() function? YEARWEEK(date, mode) is a MySQL built-in function that calculates the year week combination from a given date. For example: SELECT YEARWEEK('2024-03-04'), WEEK('2024-03-04'); -- +------------------------+---- ... 2023-11-16, 1438🔥, 0💬

TRUNCATE() - Truncating to Decimal Place
How to truncate a value to a given decimal place using the TRUNCATE() function? TRUNCATE(X, D) is a MySQL built-in function that truncates X to decimal place of D. For example: SELECT TRUNCATE(-1.58, 0), TRUNCATE(23.298, 1), TRUNCATE(23.298, -1); -- +--------------------+-------- -------------+------... 2023-11-14, 1387🔥, 0💬

UPPER() - Convert String to Upper Case
How to convert a string to upper case using the UPPER() function? UPPER(str) is a MySQL built-in function that converts all characters of a given into upper case characters. For example: SET @str = 'dba.FYIcenter.com'; SELECT UPPER(@str); -- +-------------------+ -- | UPPER(@str) | -- +-------------... 2023-11-13, 1379🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.