From d2ce9f3eaf4bbd0ce97f8158ee676a56c8e00a1a Mon Sep 17 00:00:00 2001 From: Jon Bergli Heier Date: Mon, 3 May 2010 14:46:11 +0200 Subject: quotes: Fixed timestamp when adding quotes. --- modules/quotes.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules') diff --git a/modules/quotes.py b/modules/quotes.py index 3592451..13c8a6d 100644 --- a/modules/quotes.py +++ b/modules/quotes.py @@ -27,7 +27,7 @@ class Quotes: def add(self, nick, quote): cur = self.db.cursor() - cur.execute('insert into quotes (nick, date, quote) values (%s, %s, %s)', (nick, int(time.time()), quote)) + cur.execute('insert into quotes (nick, date, quote) values (%s, datetime("now"), %s)', (nick, quote)) cur.execute('select currval(\'quotes_id_seq\')') lastrowid = cur.fetchone()[0] cur.close() -- cgit v1.2.3