conversion of datetime Field to string in django queryset.values_list()

by

https://docs.djangoproject.com/en/2.2/ref/models/fields/#datetimefield

A date and time, represented in Python by a datetime.datetime instance.

You can get a string representation of a DateTimeField casting it directly:

str(obj)
# obj = qs[0][0] ? or qs[0][1] ?

You’ll get result like this (in this example I use datetime.datetime.now() since a DateTimeField is represented by datetime.datetime is the same behavior):

>>> now = datetime.datetime.now()
>>> str(now)
'2013-06-26 00:14:26.260524'

if you want less information or formatted in other mode you can use strftime() function for format them. see:

>>> now.strftime('%Y-%m-%d %H:%M')
'2013-06-26 00:14'

More Related Contents:

  1. How to register users in Django REST framework?
  2. (13: Permission denied) while connecting to upstream:[nginx]
  3. What does on_delete do on Django models?
  4. Django: How can I protect against concurrent modification of database entries
  5. Django: Populate user ID when saving a model
  6. Get model’s fields in Django
  7. Can django’s auth_user.username be varchar(75)? How could that be done?
  8. Override default queryset in Django admin
  9. Custom QuerySet and Manager without breaking DRY?
  10. Django: Query using contains each value in a list
  11. How can I have two foreign keys to the same model in Django?
  12. How do you serialize a model instance in Django?
  13. Django migrate –fake and –fake-initial explained
  14. How to make email field unique in model User from contrib.auth in Django
  15. Why does django’s prefetch_related() only work with all() and not filter()?
  16. Select DISTINCT individual columns in django?
  17. Django ModelForm override widget
  18. Django – how to specify a database for a model?
  19. “Post Image data using POSTMAN”
  20. How to add data into ManyToMany field?
  21. Raw SQL queries in Django views
  22. Django model: delete() not triggered
  23. Django – filtering on foreign key properties
  24. Django unique_together with nullable ForeignKey
  25. Django Order By Date, but have “None” at end?
  26. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  27. Password field in Django model
  28. Creating Partial Indexes with Django 1.7
  29. Django: dynamic database file
  30. Django Rest framework, how to include ‘__all__’ fields and a related field in ModelSerializer ?

Leave a Comment