[python] Re: time, DateTime a MySQLdb

[Zdeněk Böhm]

Neni treba to delat tak komplikovane, kdyz to jde takto: (SQL sloupec datum
musi byt typu datetime)

CAS1 = time.time()
sqlcas = time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(CAS1))
SQL = "INSERT INTO data(datum) VALUES ('%s')" % sqlcas
....
SQL = "SELECT UNIX_TIMESTAMP(datum) FROM data WHERE ..."
rettuple = cursor.fetchone()
# rettuple -> (1090011220L,)
CAS2 = rettuple[0]
if long(CAS1) == CAS2:
        print "Cas je opravdu shodny! :-)"

Z.B.