You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
import nzpy
conn = nzpy.connect(user="admin", password="password",host='localhost', port=5480, database="db1", securityLevel=1,logLevel=0)
with conn.cursor() as cursor:
try:
cursor.execute("SELECT CREATEDATE FROM _V_TABLE_STORAGE_STAT LIMIT 1")
results = cursor.fetchall()
for c1, in results:
print(c1)
except Exception as e:
print(str(e))
RESULTS results
Notice IBM Netezza ODBC driver is fine (datatime is returned), Java and NET driver have similar issues (return integer ins Java , byte array.. in NET)
Notice2 seems than this equation works
'1970-01-01' + numer returned by driver [seconds] = real datetime
The text was updated successfully, but these errors were encountered:
Abstime data type is treated as integer
Article from IBM
https://www.ibm.com/support/pages/how-use-abstime-data-type-nzsql
place in code (not handled 702)
nzpy/nzpy/core.py
Line 1336 in e71bf64
Timestamp
RESULTS results
![image](https://user-images.githubusercontent.com/69449360/156880154-9e7a309b-5c29-4730-9e7b-04c05a8e177c.png)
Notice IBM Netezza ODBC driver is fine (datatime is returned), Java and NET driver have similar issues (return integer ins Java , byte array.. in NET)
Notice2 seems than this equation works
The text was updated successfully, but these errors were encountered: