{"action":"created","issue":{"url":"https://api.github.com/repos/darold/ora2pg/issues/736","repository_url":"https://api.github.com/repos/darold/ora2pg","labels_url":"https://api.github.com/repos/darold/ora2pg/issues/736/labels{/name}","comments_url":"https://api.github.com/repos/darold/ora2pg/issues/736/comments","events_url":"https://api.github.com/repos/darold/ora2pg/issues/736/events","html_url":"https://github.com/darold/ora2pg/issues/736","id":386266456,"node_id":"MDU6SXNzdWUzODYyNjY0NTY=","number":736,"title":"conversion issue TIMEZONE_*","user":{"login":"buragaddapavan","id":43881608,"node_id":"MDQ6VXNlcjQzODgxNjA4","avatar_url":"https://avatars3.githubusercontent.com/u/43881608?v=4","gravatar_id":"","url":"https://api.github.com/users/buragaddapavan","html_url":"https://github.com/buragaddapavan","followers_url":"https://api.github.com/users/buragaddapavan/followers","following_url":"https://api.github.com/users/buragaddapavan/following{/other_user}","gists_url":"https://api.github.com/users/buragaddapavan/gists{/gist_id}","starred_url":"https://api.github.com/users/buragaddapavan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buragaddapavan/subscriptions","organizations_url":"https://api.github.com/users/buragaddapavan/orgs","repos_url":"https://api.github.com/users/buragaddapavan/repos","events_url":"https://api.github.com/users/buragaddapavan/events{/privacy}","received_events_url":"https://api.github.com/users/buragaddapavan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-30T16:48:15Z","updated_at":"2018-12-12T12:01:37Z","closed_at":"2018-12-12T08:49:11Z","author_association":"NONE","body":"ora2pg not able to convert from oracle attr TIMEZONE_HOUR to postgres support attr HOUR.. im facing this issue in tables ,triggers, packages, functions ..\r\n\r\nsimilarly  fix for\r\n* TIMEZONE_MINUTE\r\n* TIMEZONE_REGION\r\n* TIMEZONE_ABBR\r\n\r\n\r\noracle DDL: \r\n```\r\nCREATE TABLE IVRROD.HUC_CAMPAIGN\r\n(\r\n  CACS_LOCATION_CODE            VARCHAR2(6 BYTE),\r\n  CACS_ACCT_NUM                 VARCHAR2(18 BYTE) DEFAULT '  ' NOT NULL,\r\n  IVR_CALL_ID_WIN2_AT1          VARCHAR2(10 BYTE) DEFAULT '  ',\r\n  IVR_CALL_ID_WIN2_AT2          VARCHAR2(10 BYTE) DEFAULT '  ',\r\n  IN_USE                        VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL,\r\n  ATTEMPT_NUM_WAS_BUSY_WIN1     VARCHAR2(3 BYTE) DEFAULT 0 NOT NULL,\r\n  ATTEMPT_NUM_WAS_BUSY_WIN2     VARCHAR2(3 BYTE) DEFAULT 0 NOT NULL,\r\n  NEXT_TIME_TO_DIAL_AFTER_BUSY  DATE            DEFAULT SYSTIMESTAMP AT TIME ZONE 'US/Eastern' NOT NULL,\r\n  TIME_WINDOW_INDICATOR         VARCHAR2(40 BYTE) DEFAULT '  ',\r\n  HOURS_OFFSET_FROM_GMT         NUMBER          DEFAULT (extract(TIMEZONE_HOUR from SYSTIMESTAMP)),\r\n  STATUS_WINDOW3_AT1            VARCHAR2(40 BYTE) DEFAULT '   ',\r\n  KILL_DATE_TIME                DATE,\r\n  LANG_INDICATOR                VARCHAR2(1 BYTE) DEFAULT ' ' NOT NULL,\r\n  DATE_TIME_STAMP               DATE\r\n);\r\n```"},"comment":{"url":"https://api.github.com/repos/darold/ora2pg/issues/comments/446563783","html_url":"https://github.com/darold/ora2pg/issues/736#issuecomment-446563783","issue_url":"https://api.github.com/repos/darold/ora2pg/issues/736","id":446563783,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NjU2Mzc4Mw==","user":{"login":"buragaddapavan","id":43881608,"node_id":"MDQ6VXNlcjQzODgxNjA4","avatar_url":"https://avatars3.githubusercontent.com/u/43881608?v=4","gravatar_id":"","url":"https://api.github.com/users/buragaddapavan","html_url":"https://github.com/buragaddapavan","followers_url":"https://api.github.com/users/buragaddapavan/followers","following_url":"https://api.github.com/users/buragaddapavan/following{/other_user}","gists_url":"https://api.github.com/users/buragaddapavan/gists{/gist_id}","starred_url":"https://api.github.com/users/buragaddapavan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buragaddapavan/subscriptions","organizations_url":"https://api.github.com/users/buragaddapavan/orgs","repos_url":"https://api.github.com/users/buragaddapavan/repos","events_url":"https://api.github.com/users/buragaddapavan/events{/privacy}","received_events_url":"https://api.github.com/users/buragaddapavan/received_events","type":"User","site_admin":false},"created_at":"2018-12-12T12:01:37Z","updated_at":"2018-12-12T12:01:37Z","author_association":"NONE","body":"select EXTRACT(TIMEZONE_HOUR FROM CURRENT_TIMESTAMP AT TIME ZONE 'US/Eastern')\r\nERROR:  timestamp units \"timezone_hour\" not supported\r\nSQL state: 0A000\r\n\r\ngetting error ."}}
{"actor":{"display_login":"buragaddapavan"}}