SYSDATE
The SYSDATE function returns the current date and time. It has no arguments.
NOTE. The function is available to use only on working with Oracle DBMS.
BIRTHDATE <= SYSDATE
The value of the BIRTHDATE field cannot be more than the current date.
USERENV('Option')
The USERENV function returns a value containing information on the current session based on the Option parameter. The Option parameter may take the following values:
LANGUAGE. Returns the language and the territory which are used during the session and the database symbols' set. A returned value looks as follows: language_territory.characterset. For example: RUSSIAN_CIS.CL8MSWIN1251.
TERMINAL. Returns identifier of the terminal used during the current session.
SESSIONID. Returns identifier of the auditing session.
ENTRYID. Returns available identifier of the auditing record.
LANG. Returns ISO abbreviation for the language of the current session. For example: RU.
NOTE. The function is available to use only on working with Oracle DBMS.
USER_LNG = USERENV('LANG')
The USER_LNG field (type String) may contain only the language of the current session.
See also: