## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> NEW_TIME[NEW_TIME]:::quoted
NEW_TIME --> End((END))
```
## Purpose
The `NEW_TIME` SQL function converts a date/time from one time zone to another time zone. The time zones can be specified using an Oracle-style abbreviation such as `AST` or `PDT`, a general abbreviation such as `AEST`, or an operating system time zone name. The supported time zones are listed in [[Time Zones]].
Parameters:
- Date (`datetime`): the date/time to convert.
- From time zone (`varchar2`): the time zone the date/time is in, as described in [[Time Zones]].
- To time zone (`varchar2`): the time zone to convert the date/time to, as described in [[Time Zones]].
Returns: the date/time converted to the new time zone as `datetime`.
## Examples
The following example converts noon Atlantic Standard Time (UTC-4) to Alaska-Hawaii Standard Time (UTC-10):
```sql
select to_char(new_time(to_date('20260703 12:00:00', 'YYYYMMDD HH24:MI:SS'), 'AST', 'HST'), 'YYYY-MM-DD HH24:MI:SS')
-------------------
2026-07-03 06:00:00
```
The following example converts midnight UTC to Australian Eastern Standard Time (UTC+10):
```sql
select to_char(new_time(to_date('2020-01-01T00:00:00Z'), 'UTC', 'AEST'), 'YYYY-MM-DD HH24:MI:SS')
-------------------
2020-01-01 10:00:00
```