python-oracledb this client incorrect database timestamp · oracle/python-oracledb · Discussion #131 (original) (raw)

Ok, i'l try insert random date in table. This script to fill data:

CREATE TABLE FOR_TEST ( BATCH_ID NUMBER NOT NULL CONSTRAINT FOR_TEST_BATCH_ID_PK PRIMARY KEY, BATCH_NAME VARCHAR2(100) NOT NULL, SCHEDULE_DATE TIMESTAMP(6) WITH TIME ZONE, MIG_START TIMESTAMP(6) WITH TIME ZONE, MIG_END TIMESTAMP(6) WITH TIME ZONE ) ORGANIZATION INDEX /

CREATE SEQUENCE FOR_TEST_SEQ START WITH 2000 INCREMENT BY 1;

INSERT INTO MIG.FOR_TEST SELECT FOR_TEST_SEQ.NEXTVAL AS BATCHID, 'batch' || DBMS_RANDOM.STRING('U', TRUNC(DBMS_RANDOM.VALUE(1, 10))) AS BATCH_NAME, TO_TIMESTAMP(SYSDATE) + (DBMS_RANDOM.VALUE(0, 186400) / 86400) AS SCHEDULE_DATE, CURRENT_TIMESTAMP + NUMTODSINTERVAL(DBMS_RANDOM.VALUE(1, 24 * 60 * 60), 'second') AS MIG_START, NULL AS MIG_END FROM DUAL CONNECT BY LEVEL <= 50;

SELECT * FROM MIG.FOR_TEST;

image

Now, i use early python script to fetch data, this is output :

(3105, 'batch_NUOO', datetime.datetime(2023, 1, 31, 3, 38, 34), datetime.datetime(2023, 1, 30, 17, 11, 15, 789610), None) (3106, 'batch_SEATAU', datetime.datetime(2023, 1, 30, 18, 40, 52), datetime.datetime(2023, 1, 30, 11, 38, 59, 158398), None) (3107, 'batch_IIBBFWW', datetime.datetime(2023, 1, 30, 16, 15, 8), datetime.datetime(2023, 1, 30, 19, 7, 26, 363551), None) (3108, 'batch_X', datetime.datetime(2023, 1, 31, 1, 56, 25), datetime.datetime(2023, 1, 30, 18, 14, 32, 497015), None) (3109, 'batch_FCRXBVL', datetime.datetime(2023, 1, 30, 6, 32, 49), datetime.datetime(2023, 1, 31, 9, 21, 5, 375904), None) (3110, 'batch_KUKDA', datetime.datetime(2023, 1, 31, 12, 43, 29), datetime.datetime(2023, 1, 31, 7, 45, 43, 948412), None) (3111, 'batch_AIAB', datetime.datetime(2023, 1, 31, 13, 25, 34), datetime.datetime(2023, 1, 30, 23, 9, 50, 437856), None) (3112, 'batch_VVMATX', datetime.datetime(2023, 1, 31, 21, 49, 19), datetime.datetime(2023, 1, 31, 6, 51, 44, 159577), None) (3113, 'batch_XUVGJXET', datetime.datetime(2023, 1, 30, 8, 22, 14), datetime.datetime(2023, 1, 30, 22, 19, 22, 466494), None) (3114, 'batch_FN', datetime.datetime(2023, 1, 31, 15, 38, 18), datetime.datetime(2023, 1, 31, 2, 26, 15, 434777), None) (3115, 'batch_JYMY', datetime.datetime(2023, 1, 30, 10, 46, 6), datetime.datetime(2023, 1, 31, 7, 1, 34, 711922), None) (3116, 'batch_MJBPJXSJI', datetime.datetime(2023, 1, 31, 8, 16, 30), datetime.datetime(2023, 1, 30, 17, 21, 15, 215999), None) (3117, 'batch_JOAD', datetime.datetime(2023, 1, 30, 9, 42, 49), datetime.datetime(2023, 1, 31, 6, 19, 12, 169254), None) (3118, 'batch_HF', datetime.datetime(2023, 1, 30, 12, 48, 23), datetime.datetime(2023, 1, 30, 17, 8, 32, 279497), None) (3119, 'batch_EK', datetime.datetime(2023, 1, 31, 5, 34, 1), datetime.datetime(2023, 1, 31, 4, 12, 4, 161156), None) (3120, 'batch_Q', datetime.datetime(2023, 1, 31, 16, 35, 49), datetime.datetime(2023, 1, 30, 20, 0, 12, 194808), None) (3121, 'batch_VLP', datetime.datetime(2023, 1, 30, 16, 37, 10), datetime.datetime(2023, 1, 31, 2, 24, 42, 336425), None) (3122, 'batch_BRROPC', datetime.datetime(2023, 1, 31, 17, 12, 46), datetime.datetime(2023, 1, 31, 5, 12, 57, 107783), None) (3123, 'batch_DDUDI', datetime.datetime(2023, 1, 30, 5, 9, 5), datetime.datetime(2023, 1, 30, 14, 5, 15, 484685), None) (3124, 'batch_TOHKNL', datetime.datetime(2023, 1, 31, 16, 20, 1), datetime.datetime(2023, 1, 31, 1, 19, 0, 454082), None) (3125, 'batch_RZQE', datetime.datetime(2023, 1, 31, 9, 38, 14), datetime.datetime(2023, 1, 30, 15, 53, 18, 66280), None) (3126, 'batch_MTXHYZQH', datetime.datetime(2023, 1, 31, 6, 8, 10), datetime.datetime(2023, 1, 30, 18, 46, 48, 21517), None) (3127, 'batch_KRVAAKSA', datetime.datetime(2023, 1, 31, 19, 57, 47), datetime.datetime(2023, 1, 30, 12, 49, 10, 478113), None) (3128, 'batch_QBJ', datetime.datetime(2023, 1, 31, 7, 34, 17), datetime.datetime(2023, 1, 30, 17, 36, 16, 941753), None) (3129, 'batch_IXG', datetime.datetime(2023, 1, 31, 10, 11, 27), datetime.datetime(2023, 1, 31, 8, 29, 58, 282827), None) (3130, 'batch_KGATYHW', datetime.datetime(2023, 1, 30, 8, 30, 22), datetime.datetime(2023, 1, 31, 6, 28, 9, 949998), None) (3131, 'batch_GS', datetime.datetime(2023, 1, 31, 9, 56, 3), datetime.datetime(2023, 1, 31, 7, 8, 44, 721823), None) (3132, 'batch_ALFW', datetime.datetime(2023, 1, 31, 21, 9, 41), datetime.datetime(2023, 1, 31, 8, 23, 17, 412944), None) (3133, 'batch_HDOGWXXK', datetime.datetime(2023, 2, 1, 5, 56, 40), datetime.datetime(2023, 1, 30, 17, 37, 17, 143241), None) (3134, 'batch_RPZIHV', datetime.datetime(2023, 1, 31, 20, 16, 28), datetime.datetime(2023, 1, 31, 11, 26, 28, 228584), None) (3135, 'batch_AFX', datetime.datetime(2023, 1, 31, 16, 20, 35), datetime.datetime(2023, 1, 31, 0, 55, 29, 389936), None) (3136, 'batch_MFSDKEV', datetime.datetime(2023, 2, 1, 5, 35, 10), datetime.datetime(2023, 1, 30, 23, 55, 44, 791108), None) (3137, 'batch_RWRWJLWV', datetime.datetime(2023, 1, 31, 15, 19, 10), datetime.datetime(2023, 1, 31, 9, 22, 47, 246294), None) (3138, 'batch_E', datetime.datetime(2023, 1, 31, 20, 30, 52), datetime.datetime(2023, 1, 30, 21, 47, 22, 857842), None) (3139, 'batch_WBTNW', datetime.datetime(2023, 1, 31, 21, 55, 17), datetime.datetime(2023, 1, 30, 12, 41, 4, 854328), None) (3140, 'batch_PBIOV', datetime.datetime(2023, 1, 30, 14, 47, 47), datetime.datetime(2023, 1, 30, 15, 27, 26, 715095), None) (3141, 'batch_GVZDEF', datetime.datetime(2023, 2, 1, 0, 29, 34), datetime.datetime(2023, 1, 30, 15, 20, 46, 977682), None) (3142, 'batch_DZXJCAC', datetime.datetime(2023, 1, 31, 18, 53, 13), datetime.datetime(2023, 1, 31, 8, 44, 0, 803645), None) (3143, 'batch_ARAZMSEGR', datetime.datetime(2023, 1, 31, 9, 13, 27), datetime.datetime(2023, 1, 31, 1, 51, 14, 11294), None) (3144, 'batch_CNXFI', datetime.datetime(2023, 1, 30, 4, 35, 47), datetime.datetime(2023, 1, 30, 18, 50, 44, 234419), None) (3145, 'batch_PESLFYB', datetime.datetime(2023, 1, 31, 6, 21, 37), datetime.datetime(2023, 1, 30, 20, 31, 48, 334213), None) (3146, 'batch_HPMGDBYAG', datetime.datetime(2023, 1, 31, 20, 5, 5), datetime.datetime(2023, 1, 31, 5, 30, 32, 285549), None) (3147, 'batch_IGGAFGKK', datetime.datetime(2023, 1, 31, 16, 41, 3), datetime.datetime(2023, 1, 31, 3, 39, 6, 482986), None) (3148, 'batch_PKGPCMWQL', datetime.datetime(2023, 1, 31, 21, 58, 7), datetime.datetime(2023, 1, 30, 14, 48, 2, 881996), None) (3149, 'batch_SMBNDACW', datetime.datetime(2023, 1, 31, 11, 29, 17), datetime.datetime(2023, 1, 31, 10, 9, 33, 602145), None) (3150, 'batch_FYRPIUFI', datetime.datetime(2023, 1, 31, 6, 34, 23), datetime.datetime(2023, 1, 31, 3, 37, 14, 494402), None) (3151, 'batch_BIPXOLBY', datetime.datetime(2023, 1, 31, 8, 53, 24), datetime.datetime(2023, 1, 31, 0, 34, 17, 377892), None) (3152, 'batch_HUEFIGAR', datetime.datetime(2023, 1, 31, 4, 51, 8), datetime.datetime(2023, 1, 30, 15, 39, 15, 433013), None) (3153, 'batch_BVYXR', datetime.datetime(2023, 1, 30, 12, 23, 26), datetime.datetime(2023, 1, 30, 15, 22, 44, 63852), None) (3154, 'batch_QF', datetime.datetime(2023, 1, 30, 12, 6, 26), datetime.datetime(2023, 1, 30, 19, 33, 5, 846982), None)

All data incorrect, difference about 3 days and 4 hours. If i count correctly