CURRENT DATE function
Derby Reference Manual
124
CURRENT DATE function
CURRENT DATE is a synonym for
CURRENT_DATE function
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
or, alternately
CURRENT DATE
Example
-- find available future flights:
SELECT * FROM Flightavailability where flight_date > CURRENT_DATE;
CURRENT ISOLATION function
CURRENT ISOLATION returns the current isolation level as a char(2) value of either
""(blank), "UR", "CS", "RS", or "RR".
Syntax
CURRENT ISOLATION
Example
VALUES CURRENT ISOLATION
CURRENT_ROLE function
CURRENT_ROLE returns the authorization identifier of the current role. If there is no
current role, it returns NULL.
This function returns a string of up to 258 characters. This is twice the length of an
identifier (128*2) + 2, to allow for quoting.
Syntax
CURRENT_ROLE
Example
VALUES CURRENT_ROLE
CURRENT SCHEMA function
CURRENT SCHEMA returns the schema name used to qualify unqualified database
object references.
Note: CURRENT SCHEMA and CURRENT SQLID are synonyms.
These functions return a string of up to 128 characters.
Syntax
