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
2023-11-17, 1816🔥, 0💬
Related Topics:
