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!

Hasan Ramezani · Accepted Answer · 2014-10-30T22:55:48.853

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.

edited Oct 30 '14 at 22:55

answered Oct 30 '14 at 22:14

Hasan Ramezani

5,004
24
30

doesn't `timezone.now()` include the timezone though? – robert Oct 30 '14 at 22:19
no, check `timezone.is_aware(timezone.now())` and see result. – Hasan Ramezani Oct 30 '14 at 22:29
okay can I just use pytz to convert it? I have `"viewed_date" <= \'timezone.localtime(datetime.now(), is_dst=None)\'` now – robert Oct 30 '14 at 22:45

Compare Postgresql timestamp to timezone in sql query in django

1 Answers1