Django F-expression transform output value

Question

I'm using an F-expression to get a foreign key object's date value. But it returns a datetime object as the date. How can I transform it to 'YYYY-MM-DD' format?

from django.db.models import F

PendingRequest.objects.all().values('id', creation_date=F('agreement__created_at__date'))

output:
<QuerySet [
{'id': 1, 'creation_date': datetime.date(2022, 10, 16)},
{'id': 2, 'creation_date': datetime.date(2022, 10, 16)},
...

Does this answer your question? conversion of datetime Field to string in django queryset.values_list() — 0urz4g
– 0urz4g, Commented Oct 20, 2023 at 7:06

willeM_ Van Onsem · Accepted Answer · 2023-10-20 13:10:06Z

1

But it returns a datetime object as the date. How can I transform it to 'YYYY-MM-DD' format?

Please, don't use the database to format dates or strings. Databases should not be used to render data. Databases are used to store, retrieve and aggregate data.

It is the task of the templates, serializers, etc. to provide the data in an accessible format. For example in the template, you can format a date with the |date template filter ^[Django-doc]:

{{ my_date|date:"Y-m-d" }}

Django also can serialize data ^[Django-doc], if you serialize it to JSON, it will also encod it in that format:

>>> json.dumps(date(2023, 10, 20), cls=DjangoJSONEncoder)
'"2023-10-20"'

answered Oct 20, 2023 at 13:10

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Collectives™ on Stack Overflow

Django F-expression transform output value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related