from django.db.models import F, Func, Value, CharField qs.annotate( formatted_date=Func( F('created_at'), Value('DD-MM-YYYY HH:MM:SS'), function='to_char', output_field=CharField() ) )