Breaking News: Grepper is joining You.com. Read the official announcement!

how to get total seconds in django queryset for timedelta field

Anies answered on July 14, 2022 Popularity 3/10 Helpfulness 2/10

answer how to get total seconds in django queryset for timedelta field

how to get total seconds in django queryset for timedelta field

Comment

"""
Sure can, but the exact mechanism may depend upon your database.

In postgres, you can use EXTRACT(epoch FROM <interval>) to get the total number of seconds.

To use this in Django, you can create a Func subclass:

"""

class Epoch(django.db.models.expressions.Func):
    template = 'EXTRACT(epoch FROM %(expressions)s)::INTEGER'
    output_field = models.IntegerField()
    
#Then you can use it directly:

base_posts.annotate(
    response_time_sec=Epoch(F('min_comment_date') - F('date_created'))
)


"""
reference:
https://stackoverflow.com/questions/63905443/django-queryset-return-durationfield-value-in-seconds
"""

Popularity 3/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: django-queryset field get python seconds timedelta

Link to this answer
Share Copy Link