The NEW_TIME Function : NEW_TIME « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NEW_TIME

The NEW_TIME function finds out the time in the time zones passing the date and time of the first zone, and specifying the second zone.

The Syntax for the NEW_TIME Function

NEW_TIME(input_date and time,time_zone1,time_zone2)

What are the valid time zones

Time Zone Abbreviation PassedTime Zone Description
ASTAtlantic Standard Time
ADTAtlantic Daylight Saving Time
BSTBering Standard Time
BDTBering Daylight Saving Time
CSTCentral Standard Time
CDTCentral Daylight Saving Time
ESTEastern Standard Time
EDTEastern Daylight Saving Time
GMTGreenwich Mean Time (Date Line!)
HSTAlaska-Hawaii Standard Time
HDTAlaska-Hawaii Daylight Saving Time
MSTMountain Standard Time
MDTMountain Daylight Saving Time
NSTNewfoundland Standard Time
PSTPacific Standard Time
PDTPacific Daylight Saving Time
YSTYukon Standard Time
YDTYukon Daylight Saving Time


13.11.NEW_TIME
13.11.1.The NEW_TIME Function
13.11.2.Converting a Datetime from One Time Zone to Another with NEW_TIME() function
13.11.3.Time Change from Chicago to Los Angeles