Django queryset TruncMonth output format issue

Question

I'm using Django ORM queryset for chart, and having difficulty with changing the format of output

'source': ActivityLog.objects.filter(requestType='add',doDate__lte=datetime.datetime.today(), doDate__gt=datetime.datetime.today()-datetime.timedelta(days=365)).\
                   values(작업월=TruncMonth('doDate')).annotate(요청건수=Count('requestType'), IP개수=Sum('ipCnt'))},

When I use 'TruncMonth' , output is like this -> 2019-10-01T00:00:00

But I want to use only 2019-10 ( YYYY-MM )...

Is there any good solution for me?

Thanks in advance.

Please use english variable names everywhere.

funnydman
– funnydman

2020-01-06 18:17:36 +00:00
Commented Jan 6, 2020 at 18:17 — funnydman
– funnydman, Commented Jan 6, 2020 at 18:17

funnydman · Accepted Answer · 2020-06-16 11:55:17Z

6

If you want to use it as a string after that, you could do:

from django.db.models import DateField, CharField
from django.db.models.functions import TruncMonth, Cast, Substr

ActivityLog.objects.values(
        result=Substr(
            Cast(TruncMonth('doDate', output_field=DateField()),
                 output_field=CharField()), 1, 7)
    )

edited Jun 16, 2020 at 11:55

answered Jan 6, 2020 at 18:28

funnydman

11.9k4 gold badges51 silver badges67 bronze badges

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

Comments

Akshay Vijay Jain · Accepted Answer · 2022-05-09 09:56:57Z

0

The purpose over here of TruncMonth is to make 1st January and 10th January equal, so that, these values can be group by Month.
If you want to print the month, you can simply print using doDate as

print(doDate.year,'-',doDate.month)

answered May 9, 2022 at 9:56

Akshay Vijay Jain

16.4k9 gold badges73 silver badges85 bronze badges

Collectives™ on Stack Overflow

Django queryset TruncMonth output format issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related