Compare Postgresql timestamp to timezone in sql query in django

Question

When I run the following query

Viewed.objects.raw('SELECT "recently_viewed_viewed"."id"FROM "recently_viewed_viewed" WHERE NOT ("recently_viewed_viewed"."viewed_date" <= \'timezone.now()\' AND "recently_viewed_viewed"."user_id" = user_id)' )

I get

DataError: invalid input syntax for type timestamp with time zone: "timezone.now()"

I've been struggling with this one haven't been able to figure it out. Any help is always appreciated!

Answer 1

django expect timestamp with time zone But you pass timestamp without time zone. you must add timezone to your time or set USE_TZ = False in your settings.py.

you can use pytz for add timezone . or use this:

timezone.now().replace(tzinfo=timezone.get_default_timezone())

for changing timezone with your setting timezone.