DATE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the date component of the given DATETIME expression.
USAGE
DATE(timestamp)
Argument Name | Description |
|---|---|
| The moment in time to convert |
DETAILS
DATE() is a datetime function that returns the date portion of the argument.
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT DATE('2001-12-31 01:02:03');
+-----------------------------+
| DATE('2001-12-31 01:02:03') |
+-----------------------------+
| 2001-12-31 |
+-----------------------------+