Sort Datetimefield by date only

Question

I wanted to order DateTimeField by date only, ignoring the time.

Because in my ordination I need to

Person.objects.order_by('-date_joined', 'full_name')

But sorting by name has no effect because the field has time, but I only wanted the date.

Answer 1

Try using the . extra

resultado = Person.objects.extra(select = 
{'date_only': 'to_date(date_joined)'}).order_by('-date_only', 'fullname')