3 files changed, 5 insertions, 3 deletions
diff --git a/famille.py b/famille.py
index efb30f7..ffc89fe 100644
--- a/famille.py
+++ b/famille.py
@@ -52,7 +52,8 @@ def query_db(query, args=(), one=False):
 
 @app.before_request
 def before_request():
-    conn = sqlite3.connect(app.config['DATABASE'])
+    conn = sqlite3.connect(app.config['DATABASE'],
+                           detect_types=sqlite3.PARSE_DECLTYPES)
     conn.row_factory = sqlite3.Row
     g.db = conn
 
diff --git a/import.py b/import.py
index 976dce4..3138e73 100644
--- a/import.py
+++ b/import.py
@@ -1,8 +1,9 @@
 import sqlite3
 import sys
+from datetime import datetime
 
 def convert_date(date):
-    return "T".join(date.split(" "))
+    return datetime.strptime(date, "%Y-%m-%d %H:%M:%S")
 
 def import_users(old_conn, new_conn):
     for row in old_conn.execute("select * from users"):
@@ -39,7 +40,7 @@ if __name__ == "__main__":
     new = sys.argv[2]
     old_conn = sqlite3.connect(old)
     old_conn.row_factory = sqlite3.Row
-    new_conn = sqlite3.connect(new)
+    new_conn = sqlite3.connect(new, detect_types=sqlite3.PARSE_DECLTYPES)
     new_conn.row_factory = sqlite3.Row
     import_users(old_conn, new_conn)
     import_news(old_conn, new_conn)
diff --git a/new.db b/new.db
index 3100ede..3335b97 100644
--- a/new.db
+++ b/new.db