General MySQL Oracle SQL Server

DATE() - Extracting Date

Q

How to obtain the date from a datetime using the DATE() function?

✍: FYIcenter.com

A

DATE(dt) is a MySQL built-in function that returns the date from a datetime. For example: 

SELECT DATE('2023-12-31 01:02:03');
  -- +-----------------------------+
  -- | DATE('2023-12-31 01:02:03') |
  -- +-----------------------------+
  -- | 2023-12-31                  |
  -- +-----------------------------+

SELECT DATE(NOW());
  -- +-------------+
  -- | DATE(NOW()) |
  -- +-------------+
  -- | 2023-11-22  |
  -- +-------------+

Reference information of the DATE() function: 

DATE(expr): dt
  Extracts the date part of the date or datetime expression expr.

Arguments, return value and availability:
  expr: Required. The datetime to extract date from.
  dt: Return value. The extracted date.
  Available since MySQL 4.

Related MySQL functions:

 

⇒ DATEDIFF() - Difference of Two Dates

⇐ CURTIME() - Current Time

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 1010🔥, 0💬

General MySQL Oracle SQL Server