jabber db example

#1 hour = 3600000000 microseconds * X-number-of-hours
microseconds = int(round(time.time() * 1000000)) - (3600000000 * 1)

conn = sqlite3.connect(file)
cur = conn.cursor()
cur.execute("SELECT date, payload, sender " + \
            "FROM history_message " + \
            "WHERE CAST(date AS Character(32)) >= '{0}%'".format(str(microseconds)))
rows = cur.fetchall()
conn.close()