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
14453	typecast_timestamp in db.backends.util gives incorrect behavior	philipn	nobody	"{{{
In [9]: typecast_timestamp('2010-10-12 15:29:22.063202')
Out[9]: datetime.datetime(2010, 10, 12, 15, 29, 22, 63201)

In [8]: typecast_timestamp('2010-10-12 15:29:22.063201')
Out[8]: datetime.datetime(2010, 10, 12, 15, 29, 22, 63200)

In [10]: typecast_timestamp('2010-10-12 15:29:22.063205')
Out[10]: datetime.datetime(2010, 10, 12, 15, 29, 22, 63205)
}}}

This causes sqlite to give occasional incorrect results when dealing with datetimes.

Suggested patch attached.  Issue is with the cast to float."		closed	Database layer (models, ORM)	1.2		fixed			Accepted	1	0	0	0	0	0