Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

Time Zone-Related Functions

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.