在Python中验证Oracle日期

pip install cx_Oracle

import cx_Oracle

# 连接到Oracle数据库
dsn = cx_Oracle.makedsn("主机名", "端口号", service_name="服务名")
conn = cx_Oracle.connect(user="用户名", password="密码", dsn=dsn)

# 创建游标
cursor = conn.cursor()

# 执行查询
cursor.execute("SELECT DATE_COLUMN FROM TABLE_NAME WHERE ID = :id", {"id": 1})

# 获取查询结果
result = cursor.fetchone()

# 关闭游标和连接
cursor.close()
conn.close()

# 打印查询结果
print(result)

from datetime import datetime

# 将Oracle日期转换为Python日期
oracle_date = result[0]
python_date = oracle_date.timestamp()
python_date = datetime.fromtimestamp(python_date)

# 打印Python日期
print(python_date)