CURRENT_DATE CURRENT_DATE returns a timestamp value for the current date with the time set to 00:00:00.0: Timestamp CURRENT_DATE() Example The following code: SELECT CURRENT_DATE() returns: 2004-10-27 00:00:00.0