问题:

每当我得到以下查询的结果时:

"SELECT email, url, `timestamp` FROM `transaction` WHERE `email` != '' AND `timestamp` >= \'" + dateonlystring + "\' AND `timestamp` < DATE(DATE_ADD(\'" + dateonlystring + "\', INTERVAL 1 DAY))"


这出现了:

('sampleemail@yahoo.com','http://sample.url.com',datetime.datetime(2015,2,25,10,11,19))

为什么是datetime.datetime(2015,2,25,10,11,19))?

以及如何将其转换为:

sampleemail@yahoo.com~ http://sample.url.com~2015-02-25 10:11:19

我的代码/我尝试过的内容:

#Date
#datestamp = datetime.strptime('2015-02-25 00:00:00', "%Y-%m-%d %H:%M:%S")
datestamp = datetime.now()
dateonlystring = str(datestamp.date().strftime("%Y-%m-%d %H:%M:%S"))
datetimestring = str(datestamp.now().strftime("%Y%m%d%H%M%S"))

#Dunchangeme:
#Query:
q_getstuff = "SELECT email, url, `timestamp` FROM `transaction` WHERE `email` != '' AND `timestamp` >= \'" + dateonlystring + "\' AND `timestamp` < DATE(DATE_ADD(\'" + dateonlystring + "\', INTERVAL 1 DAY))"

try:
    con = mdb.connect(hostname, username, password, database)
    cur = con.cursor()
    cur.execute(q_getstuff)
    result = cur.fetchall()

    for row in result:
        tuplecrap = str(row).replace('(', '').replace(')', '').replace('\'', '').replace(', ', '~')
        print tuplecrap


值得注意的是,如果用户打算去特定的日期(而不是现在),则注释的第一个datestamp在那里。

最简单的方法是像我在上面那样简单地去除括号和逗号,但是如果不使用复杂的正则表达式解决方案就无法解决问题,而且我敢肯定这不是正确的方法。

有什么建议么?

最佳答案

您在每个结果行中都有包含3个项目的元组,只需将其解压缩即可:

for row in result:
    email, url, date = row
    # here you can format date as you want

关于python - python tuple返回datetime.datetime,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/28724968/

10-14 17:53
查看更多