CURRENT_DATE functionThe CURRENT_DATE function returns the current date; the value
returned does not change if it is executed more than once in a single
statement.CURRENT_DATE function
This means the value is fixed even if there is a long delay between
fetching rows in a cursor.
SyntaxCURRENT_DATE
or,
alternately
CURRENT DATEExample-- find available future flights:
SELECT * FROM Flightavailability where flight_date > CURRENT_DATE;