class TruncDay(expression, output_field=None, tzinfo=None, **extra) [source] kind = 'day'

class TruncDate(expression, **extra) [source] lookup_name = 'date' output_field = DateField() TruncDate casts expression to a date rather than using the built-in SQL truncate function. It’s also registered as a transform on DateTimeField as __date.

class Trunc(expression, kind, output_field=None, tzinfo=None, **extra) [source] Truncates a date up to a significant component. When you only care if something happened in a particular year, hour, or day, but not the exact second, then Trunc (and its subclasses) can be useful to filter or aggregate your data. For example, you can use Trunc to calculate the number of sales per day. Trunc takes a single expression, representing a DateField or DateTimeField, a kind representing a date part, and

class ExtractYear(expression, tzinfo=None, **extra) [source] lookup_name = 'year'

class ExtractWeekDay(expression, tzinfo=None, **extra) [source] lookup_name = 'week_day' These are logically equivalent to Extract('date_field', lookup_name). Each class is also a Transform registered on DateField and DateTimeField as __(lookup_name), e.g. __year. Since DateFields don’t have a time component, only Extract subclasses that deal with date-parts can be used with DateField: >>> from datetime import datetime >>> from django.utils import timezone >>>

class ExtractSecond(expression, tzinfo=None, **extra) [source] lookup_name = 'second' These are logically equivalent to Extract('datetime_field', lookup_name). Each class is also a Transform registered on DateTimeField as __(lookup_name), e.g. __minute. DateTimeField examples: >>> from datetime import datetime >>> from django.utils import timezone >>> from django.db.models.functions import ( ... ExtractYear, ExtractMonth, ExtractDay, ExtractWeekDay, ...

class ExtractMonth(expression, tzinfo=None, **extra) [source] lookup_name = 'month'

class ExtractMinute(expression, tzinfo=None, **extra) [source] lookup_name = 'minute'

class ExtractHour(expression, tzinfo=None, **extra) [source] lookup_name = 'hour'

class ExtractDay(expression, tzinfo=None, **extra) [source] lookup_name = 'day'