FROM_TZ(x, time_zone): convert the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE : FROM_TZ « Date Timezone « Oracle PL / SQL

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

FROM_TZ(x, time_zone): convert the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE

SQL> -- FROM_TZ(x, time_zone): convert the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE
SQL>
SQL> SELECT FROM_TZ(TIMESTAMP '2005-05-13 07:15:31.1234', 'EST') FROM dual;

FROM_TZ(TIMESTAMP'2005-05-1307:15:31.1234','EST')
---------------------------------------------------------------------------
13-MAY-05 07.15.31.123400000 AM EST

SQL>




           
       

Related examples in the same category