That's fine as am using Postgres on centos 7
Cheers
Steve
Sent from my iPhone
> On 19 Jan 2016, at 21:19, Simon Charette <charett...@gmail.com> wrote:
>
> Hi Steve,
>
> It looks like it might only work on PostgreSQL unti this bug is fixed.
>
> Simon
>
> Le mardi 19 janvier 2016 14:59:57 UTC-5, Steven Nash a écrit :
>>
>> Hi Simon,
>>
>> Thanks, I'll give that ago.
>>
>> Cheers,
>>
>> Steve
>>
>>> On Tuesday, 19 January 2016 18:52:06 UTC, Simon Charette wrote:
>>> Hi Steve,
>>>
>>> You can use annotate for this.
>>>
>>> from datetime import timedelta
>>>
>>> from django.db.models import DurationField, ExpressionWrapper, F
>>>
>>> Entry.objects.annotate(
>>> duration=ExpressionWrapper(
>>> F('end') - F('start'), output_field=DurationField()
>>> )
>>> ).filter(duration__gte=timedelta(minutes=time_in_minutes)
>>>
>>>
>>> Cheers,
>>> Simon
>>>
>>> Le mardi 19 janvier 2016 13:01:36 UTC-5, Steven Nash a écrit :
>>>>
>>>> Hi,
>>>>
>>>> Given an object such as:
>>>>
>>>> class Entry(models.Model):
>>>> start = models.TimeField()
>>>> end = models.TimeField()
>>>>
>>>> I'd like to be able to say something like:
>>>>
>>>> Entry.objects.filter(F('end')-F('start')__gt=time_in_minutes)
>>>>
>>>> Is there a way of doing this without implementing a separate duration
>>>> field and having a setter for start and end update it?
>>>>
>>>> Cheers,
>>>> Steve
>
> --
> You received this message because you are subscribed to a topic in the Google
> Groups "Django users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/django-users/xIP7hhp0WqQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/3bd1db8e-0b53-4b3b-b781-51e4cc8a687c%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/1E3B4129-5341-4968-990C-3C2E8E8225A6%40bitsolver.co.uk.
For more options, visit https://groups.google.com/d/optout.
