This function returns the current date by evaluating TO_DATE(CURRENT_TIMESTAMP).
TO_DATE(CURRENT_TIMESTAMP)
current_date::=
CURDATE is an alias to this function. Refer to CURDATE for additional information.
CURDATE
SELECT CURRENT_DATE;