SQL-J Language Reference
Page 69 of 121

CURRENT_DATE

CURRENT_DATE returns the current date; the value returned does not change if it is executed more than once in a single statement. This means the value is fixed even if there is a long delay between fetching rows in a cursor.

Syntax

CURRENT_DATE

CURRENT_DATE Example

-- find hotel bookings for the future:

SELECT *
FROM HotelBookings
WHERE arrival > CURRENT_DATE