Mega Code Archive

 
Categories / Oracle PLSQL Tutorial / Date Timestamp Functions
 

The NEW_TIME Function

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