Author: russellm
Date: 2010-05-08 23:50:00 -0500 (Sat, 08 May 2010)
New Revision: 13155
Modified:
django/trunk/docs/ref/models/querysets.txt
Log:
Fixed #13282 -- Clarified documentation around week_day filtering in querysets.
Thanks to wangchun, Ramiro Morales and timo.
Modified: django/trunk/docs/ref/models/querysets.txt
===================================================================
--- django/trunk/docs/ref/models/querysets.txt 2010-05-09 04:49:11 UTC (rev
13154)
+++ django/trunk/docs/ref/models/querysets.txt 2010-05-09 04:50:00 UTC (rev
13155)
@@ -1571,16 +1571,16 @@
For date/datetime fields, a 'day of the week' match.
+Takes an integer value representing the day of week from 1 (Sunday) to 7
+(Saturday).
+
Example::
Entry.objects.filter(pub_date__week_day=2)
-SQL equivalent::
+(No equivalent SQL code fragment is included for this lookup because
+implementation of the relevant query varies among different database engines.)
- SELECT ... WHERE EXTRACT('dow' FROM pub_date) = '2';
-
-(The exact SQL syntax varies for each database engine.)
-
Note this will match any record with a pub_date that falls on a Monday (day 2
of the week), regardless of the month or year in which it occurs. Week days
are indexed with day 1 being Sunday and day 7 being Saturday.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
