How to write Django QuerySet to get UNIX_TIMESTAMP of a DateTimeField?

Question

This question is a follow-up to the one here.

Suppose I have the following Django model:

from django.db import models
from django.db.models import Sum

class myModel(models.Model):
    my_string = models.CharField(max_length=32,)
    my_date = models.DateTimeField()

    @staticmethod
    def get_stats():            
        logger.info(myModel.objects.values('my_string').annotate(
                count=Count('my_string'), 
                sum=Sum(F('my_date')+0)), #THIS NEEDS TO CHANGE. TO WHAT??
            )
        )

Instead of calculating the Sum of my_date, I would like to calculate the sum of the MySQL expression UNIX_TIMESTAMP('my_date'). How can I modify the Django QuerySet above to accomplish that?

Note: this question not a duplicate of this one because I am asking how to get this value from a QuerySet (IE: How do I get the Database to return this value). In that question, there is no Database. It is straight non-Django python. I'm using Django.

madzohan · Accepted Answer · 2023-01-23 18:12:11Z

4

Look at func-expressions

from django.db.models import Func, F, Sum

queryset.annotate(sum=Sum(Func(F('my_date'), function='UNIX_TIMESTAMP')))

edited Jan 23, 2023 at 18:12

answered Jul 7, 2015 at 22:39

madzohan

11.8k9 gold badges43 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Buck Over a year ago

I know this question was tagged MySQL, but for anyone else looking for a Postgres solution to the same problem, there is a good solution here

Collectives™ on Stack Overflow

How to write Django QuerySet to get UNIX_TIMESTAMP of a DateTimeField?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related