#24194: Oracle Backend Oprations
----------------------------------------------+--------------------
Reporter: kl4us | Owner: nobody
Type: Bug | Status: new
Component: Database layer (models, ORM) | Version: 1.7
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
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.
--
Ticket URL: <https://code.djangoproject.com/ticket/24194>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/048.49dc87a295be7c57e37e0c9db326f73c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
