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
24194	Oracle Backend Operations	kl4us	nobody	"My Object have a filed named timestamp:


{{{
timestamp = models.DateTimeField(auto_now_add=True)
}}}


When I use a function like:


{{{
from django.db import connection
extract_hour = connection.ops.datetime_trunc_sql('hh24','timestamp', None) # None because USE_TZ = False

startdate = datetime.datetime.now() - datetime.timedelta(days=1)
    MyObject.objects.filter(timestamp__gt=startdate).extra({'hour':extract_hour}).values(""hour"", ""status"").annotate(Count('pk')).order_by('hour')
}}}

the result error is:

'''DatabaseError: ORA-00907: missing right parenthesis'''

I'm using django 1.7.3 and python 2.7. 
"	Bug	closed	Database layer (models, ORM)	1.7	Normal	invalid			Accepted	0	0	0	0	0	0