UTC_TIMESTAMP() - Current UTC Timestamp

Q

How to obtain the current UTC timestamp using the UTC_TIMESTAMP() function?

✍: FYIcenter.com

A

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

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

Reference information of the UTC_TIMESTAMP() function:

UTC_TIMESTAMP(prec): datetime
  Returns the current UTC date and time as a value in 'YYYY-MM-DD
  hh:mm:ss' or YYYYMMDDhhmmss 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.
  datetime: Return value. The current UTC timestamp.
  Available since MySQL 4.

Related MySQL functions:

⇒ WEEK() - Week of Year

⇐ UTC_TIME() - Current UTC Time

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1457🔥, 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, 2361🔥, 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, 2110🔥, 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, 2093🔥, 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, 1920🔥, 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, 1865🔥, 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, 1828🔥, 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, 1815🔥, 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, 1792🔥, 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, 1755🔥, 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.