What is your model, is 'date' a DateField or a CharField? On Thu, Aug 22, 2019, 12:47 PM wd <w...@wdicc.com wrote:
> QuerySet.query is not a plain string, it's an Query object, you can check > the source code > > def __str__(self): >> """ >> Return the query as a string of SQL with the parameter values >> substituted in (use sql_with_params() to see the unsubstituted string). >> >> Parameter values won't necessarily be quoted correctly, since that is >> done by the database interface at execution time. >> """ >> sql, params = self.sql_with_params() >> return sql % params >> >> > It will not quote the params. Here is a way to get the raw sql, > https://code.djangoproject.com/ticket/17741#comment:4 , or if you can > use django-extensions , set SHELL_PLUS_PRINT_SQL = True to print sql > automatically. > > > On Tue, Aug 20, 2019 at 11:44 PM Jo <saturnix2...@gmail.com> wrote: > >> I have a Django queryset that I prepare with >> >> queryset.filter(date__gte=datetime(2011,1,1)) >> >> >> If I then call `str(queryset.query)` I see this in the string: >> >> ... WHERE "App_table"."date" >= 2011-1-1 >> >> However, this is invalid SQL code as if I run this in Postgresql I get >> this error: >> >> ... WHERE "App_table"."date" >= 2011-1-1 >> ERROR: operator does not exist: date >= integer >> HINT: No operator matches the given name and argument type(s). You >> might need to add explicit type casts. >> >> >> Why is this happening and how can I ask Django to output proper SQL code >> that I can work on? >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to django-users+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/3f7a7f2d-2e3d-4167-8b77-2b1c7da5446d%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/3f7a7f2d-2e3d-4167-8b77-2b1c7da5446d%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CABexzmiKds1bK5Kdy5bhxwgJbovfvdbCCMtNLJMtPcW7XSGJ_w%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CABexzmiKds1bK5Kdy5bhxwgJbovfvdbCCMtNLJMtPcW7XSGJ_w%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPXBATRGd2niOc1TMj%3D2Ar%3D6mHCCgBX0yAiM5yobWeAYU8_LNA%40mail.gmail.com.
