CURDATE() - Current Date

Q

How to obtain the current date using the CURDATE() function?

✍: FYIcenter.com

A

CURDATE() is a MySQL built-in function that returns the current date. For example:

SELECT CURDATE(), CURDATE()+1;
  -- +------------+-------------+
  -- | CURDATE()  | CURDATE()+1 |
  -- +------------+-------------+
  -- | 2023-11-11 |    20231112 |
  -- +------------+-------------+

Reference information of the CURDATE() function:

CURDATE(): dt
  Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD
  format, depending on whether the function is used in string or numeric
  context.

Arguments, return value and availability:
  dt: Return value. The current date as a string or number.
  Available since MySQL 4.

Related MySQL functions:

CURRENT_DATE() - Synonym for CURDATE()

⇒ CURRENT_DATE() - Synonym for CURDATE()

⇐ CONVERT_TZ() - Converting Time Zone

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1671🔥, 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, 2320🔥, 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, 2077🔥, 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, 2061🔥, 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, 1886🔥, 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, 1831🔥, 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, 1805🔥, 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, 1766🔥, 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, 1754🔥, 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, 1723🔥, 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.