NEW_TIME() returns the equivalent of the date. : NEW_TIME « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. NEW_TIME

NEW_TIME() returns the equivalent of the date.

 
SQL>
SQL>
Syntax: NEW_TIME(<date>, <zone_one>,<zone_two>)
SQL>
SQL> SELECT
  2     NEW_TIME(SYSDATE, 'PST','AST')   ast_time,
  3     SYSDATE   pst_time
  4  FROM dual;

AST_TIME  PST_TIME
--------- ---------
21-JUN-08 20-JUN-08

SQL>








Related examples in the same category

1.NEW_TIME(): Converting a Datetime from One Time Zone to Another
2.Time Change from Chicago to Los Angeles