python oracle插入数据,python 插入日期数据到Oracle

[root@yyjk DATABASE]# cat DBI.py

# -*- coding: utf-8 -*-

import cx_Oracle

import time

import datetime

class DBI (object):

def LoadDB(self,a,b):

print self

conn = cx_Oracle.connect('tlcbuser/tlcbuser@1.1.1.1/tlyy')

cursor = conn.cursor()

#coding:UTF-8

#获取当前时间

time_now = int(time.time())

#转换成localtime

#time_local = time.localtime(time_now)

#print time_local

#dt = time.strftime("%Y-%m-%d %H:%M:%S",time_local)

dt=datetime.datetime.now()

print dt

param={'stime':dt,'message':a,'phone':b}

print param;

cursor.execute('insert into tlcb_python_sms values(:stime,:message,:phone)',param)

conn.commit()

cursor.close

python 插入时间到oracle

SQL> desc tlcb_python_sms

Name Null? Type

----------------------------------------- -------- ----------------------------

STIME DATE

MESSAGE VARCHAR2(1000)

PHONE VARCHAR2(20)

[root@yyjk flask]# python test.py

lib.Mojo.Client

2017-11-10 11:37:40.173295

{'phone': '222', 'message': '111', 'stime': datetime.datetime(2017, 11, 10, 11, 37, 40, 173295)}