Django’s new Extract*() classes

in #python4 years ago

Django 1.10 and even more 1.11 comes with convenient methods for annotating date parts to your query.

Django comes with these methods in terms of date manipulating

  • ExtractYear
  • ExtractMonth
  • ExtractDay
  • ExtractWeekDay
  • ExtractWeek

and with these in terms of time

  • ExtractHour
  • ExtractMinute
  • ExtractSecond

Then you can go like:

from django.db.models.functions import ExtractWeek
my_query.annotate(week=ExtractWeek(“created”))

Here is link to the docs.

Thank you!

Coin Marketplace

STEEM 0.27
TRX 0.07
JST 0.033
BTC 23441.06
ETH 1845.15
USDT 1.00
SBD 3.19