I am using MySQL, last subversion for django and Python 2.4.4 on debian linux Tested some more with date fields and it all working fine, the problem was with datetime fields and it was my fault because I did not include the time.
Daniel On Jun 20, 9:03 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Wed, 2007-06-20 at 21:39 +0000, [EMAIL PROTECTED] wrote: > > I had some doubts about my testing because my fields are datetime. > > So I tested it some more and the same problem came up but not only on > > the admin > > > I have an app with a datetime field. Then I saved enoght objects to > > have one for each day of the month and the same results came up for: > > App.objects.filter(date__gt=datetime.datetime(2007, 5, 21, 0, 0, 0)) > > or > > App.objects.filter(date__gte=datetime.datetime(2007, 5, 21, 0, 0, 0)) > > also the same results for LTE or LT > > > its it my mistake somewhere? or is it a bug? > > We've fixed some tickets related to this in the past. I cannot remember > off the top of my head if there is still one open or not. Make sure the > problem is repeatable with the latest subversion code and the database > backend you are using will probably be significant, too. Most of the > problems that have been reported have been with SQLite (or caused by > trying to fix SQLite issues). > > So django version, database backend and Python version (because Python > 2.5 uses the builtin SQLite driver) are probably all relevant if you > open a ticket. But have a search in the database component (just scan > through the titles of all the open tickets in that component) first to > see if it's a dupe. > > Regards, > Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
