Collections:
DATE() - Extracting Date
How to obtain the date from a datetime using the DATE() function?
✍: FYIcenter.com
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, 244🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...