id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
1777	sqlite backend has small bug in date conversion	dart@…	Adrian Holovaty	"Here's a diff for the sqlite backend I was just experiencing. Part of the problem was that the tables were created with a different ORM (sqlobject) that uses a different name for the time stamp. It also need another flag to read it.


Index: django/db/backends/sqlite3/base.py

===================================================================

--- django/db/backends/sqlite3/base.py	(revision 2832)

+++ django/db/backends/sqlite3/base.py	(working copy)

@@ -11,6 +11,8 @@

 Database.register_converter(""time"", util.typecast_time)
 Database.register_converter(""date"", util.typecast_date)
 Database.register_converter(""datetime"", util.typecast_timestamp)
+Database.register_converter(""timestamp"", util.typecast_timestamp)
+Database.register_converter(""TIMESTAMP"", util.typecast_timestamp)
 
 def utf8rowFactory(cursor, row):
     def utf8(s):
@@ -35,7 +37,9 @@

     def cursor(self):
         from django.conf import settings
         if self.connection is None:
-            self.connection = Database.connect(settings.DATABASE_NAME, detect_types=Database.PARSE_DECLTYPES)
+            self.connection = Database.connect(settings.DATABASE_NAME, 
+                            detect_types=Database.PARSE_DECLTYPES|Database.PARSE_COLNAMES)
+
             # register extract and date_trun functions
             self.connection.create_function(""django_extract"", 2, _sqlite_extract)
             self.connection.create_function(""django_date_trunc"", 2, _sqlite_date_trunc)
"	defect	closed	Database layer (models, ORM)		normal	fixed			Unreviewed	0	0	0	0	0	0