Re: [sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column

2021-09-15 Thread Mike Bayer
using the "sync" engine I would assume you are using psycopg2, which is going to use native Postgresql client libraries. asyncpg I think is written in cython and doesn't actually use libpq if im reading it correctly. therefore the difference may be a libpq related setting of the local timezone

[sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column

2021-09-15 Thread Ivan Randjelovic
Hi Jonathan, I use postgres docker image from docker hub version 12 with this settings in docker-compose file: db: image: postgres:12 environment: POSTGRES_USER: test_db POSTGRES_DB: test_db POSTGRES_PASS: test_db POSTGRES_HOST_AUTH_METHOD: trust

[sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column

2021-09-14 Thread 'Jonathan Vanasco' via sqlalchemy
Can you share the database drivers / dialects you use? The discrepancy could be there. On Tuesday, September 14, 2021 at 7:03:27 AM UTC-4 ivan.ran...@themeanalytics.com wrote: > Hi all, > > I am trying to figure it out why AsyncEngine always returns UTC time for > datetime column, any help is