python获取本地时间

python本地时间

import time

# 格式化成2016-03-20 11:45:39形式
now = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())

#coding=utf-8
import sqlite3
import time

# 格式化成2016-03-20 11:45:39形式
now = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())

conn = sqlite3.connect('test.db')
cursor = conn.cursor()
for i in range(1,101):
sql = "insert into ganji(title,money,create_time) values('{}','{}','{}')".format('tttt','232',now)
#sql ="delete from ganji where id = 1"
#sql ="select * from ganji where 1"
cursor.execute(sql)
print(cursor.rowcount)
conn.commit()

conn.close()

  

posted @ 2018-04-26 11:43  brady-wang  阅读(1123)  评论(0编辑  收藏  举报