Syntax
CURRENT_DATE()
CURRENT_DATE
Purpose
You can call this function to return the current date without the time part. The function is an alias for CURDATE.
Examples
obclient> SELECT CURRENT_DATE;
+--------------+
CURRENT_DATE
+--------------+
2021-08-23
+--------------+
1 row in set (0.00 sec)
obclient> SELECT CURRENT_DATE();
+----------------+
CURRENT_DATE()
+----------------+
2021-08-23
+----------------+
1 row in set (0.00 sec)