Oracle / PLSQL: NEW_TIME Function

This article is written about how to use the Oracle/PLSQL NEW_TIME function with syntax and examples.


The Oracle/PLSQL NEW_TIME function converts a date from time zone1 to a date in time zone2.


The syntax for the NEW_TIME function in Oracle/PLSQL is:

NEW_TIME( date, zone1, zone2 )

Parameters or Arguments


Original time zone that date is currently displayed in. It can be a value from the table below.


New time zone that you wish to display result. It can be one of the values in the following table:

Value Description

AST Atlantic Standard Time

ADT Atlantic Daylight Time

BST Bering Standard Time

BDT Bering Daylight Time

CST Central Standard Time

CDT Central Daylight Time

EST Eastern Standard Time

EDT Eastern Daylight Time

GMT Greenwich Mean Time

HST Alaska-Hawaii Standard Time

HDT Alaska-Hawaii Daylight Time

MST Mountain Standard Time

MDT Mountain Daylight Time

NST Newfoundland Standard Time

PST Pacific Standard Time

PDT Pacific Daylight Time

YST Yukon Standard Time

YDT Yukon Daylight Time


The NEW_TIME function returns a date value.

Applies To

The NEW_TIME function can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i


Let’s look at some Oracle NEW_TIME function examples and explore how to use the NEW_TIME function in Oracle/PLSQL.

For example:

The following NEW_TIME function example converts an Atlantic Standard Time into a Mountain Standard Time:

NEW_TIME (TO_DATE ('2003/11/01 01:45', 'yyyy/mm/dd HH24:MI'), 'AST', 'MST')

This example would return ‘2003/10/31 10:45:00 PM’.