Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

Oracle TimeZones - America
SET SERVEROUTPUT ON;

DECLARE
   l_array  UTL_I18N.STRING_ARRAY;
   idx      SIMPLE_INTEGER :=0;

BEGIN
  DBMS_OUTPUT.ENABLE(100000);

  l_array := UTL_I18N.GET_LOCAL_TIME_ZONES('AMERICA'); 

  DBMS_OUTPUT.PUT_LINE('Time Zone Count = '||
     l_array.COUNT);

  FOR idx IN l_array.FIRST ..l_array.LAST LOOP
    DBMS_OUTPUT.PUT_LINE(idx||' '||l_array(idx));
  END LOOP;

END;
/

Oracle Timezones - America


-- For Complete Oracle TimeZones Listing

DECLARE
   l_array  UTL_I18N.STRING_ARRAY;
   idx      SIMPLE_INTEGER :=0;

BEGIN
  DBMS_OUTPUT.ENABLE(100000);

  l_array := UTL_I18N.GET_COMMON_TIME_ZONES; 

  DBMS_OUTPUT.PUT_LINE('Time Zone Count = '||
     l_array.COUNT);

  FOR idx IN l_array.FIRST ..l_array.LAST LOOP
    DBMS_OUTPUT.PUT_LINE(idx||' '||l_array(idx));
  END LOOP;
END;
/

Oracle - TimeZone Queries

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: March 18, 2015

  19113