Django - get the query by date using postgresql "to_date"

Question

I need to get raw objects using Django .objects.raw functions like :

SELECT * FROM TEST_APP_DOCUMENT WHERE DATE BETWEEN to_date('0000-02-07','YYYY-MM-DD') AND to_date('2027-02-15', 'YYYY-MM-DD')

in pgAdmin select return good result, but when i put it to django there is an error:

  File "C:\Users\User\Desktop\test_task\test_app\views.py", line 110
    queryset = Document.objects.raw('SELECT * FROM TEST_APP_DOCUMENT WHERE DATE BETWEEN to_date('0000 - 02 - 07','YYYY - MM - DD') AND to_date('2027 - 02 - 15', 'YYYY - MM - DD')')
                                                                                                    ^
SyntaxError: invalid syntax

what is the syntax problem?

Siegmeyer · Accepted Answer · 2018-07-28 11:10:00Z

1

You're passing a string literal with single parenthesis (') while having them inside the string itself. You must escape them or use ":

queryset = Document.objects.raw("SELECT * FROM TEST_APP_DOCUMENT WHERE DATE BETWEEN to_date('0000 - 02 - 07','YYYY - MM - DD') AND to_date('2027 - 02 - 15', 'YYYY - MM - DD')")

You can escape with backslash, as you'd expect. For example, 'foo\'bar' will yield foo'bar.

answered Jul 28, 2018 at 11:10

Siegmeyer

4,5427 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django - get the query by date using postgresql "to_date"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related