SQL Data Types Oracle PLSQL Tutorial

Function Description
CURRENT_DATE()Returns the current date in the local time zone set for the database session.
DBTIMEZONE()Returns the time zone for the database.
NEW_TIME(x, time_zone1, time_zone2)Converts x from time_zone1 to time_zone2 and returns the new datetime.
SESSIONTIMEZONE()Returns the time zone for the database session.
TZ_OFFSET(time_zone)Returns the offset for time_zone in hours and minutes.