Time Zone Functions

Introduction

FunctionDescription
CURRENT_DATEreturns the current date in the local time zone in the database session
DBTIMEZONEReturns the time zone for the database
NEW_TIME(x,time_zone1,time_zone2)Converts x from time_zone1 to time_zone2
SESSIONTIMEZONEReturns the database session time zone
TZ_OFFSET(time_zone)Returns the offset for time_zone in hours and minutes
SYS_EXTRACT_UTCExtracts the UTC from a datetime value.
Home »
Oracle » 
Time_Zone_Functions