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 appreciated? > > I am working with sqlalchemy core and async engine. Column definition: > *Column('test', DateTime(timezone=True), nullable=False)* > > Also tried with this, but no luck: > > *_connect_args = {'server_settings': {'timezone': > ''America/New_York''}}async_db: AsyncEngine = > create_async_engine(async_url_from_config(), connect_args=_connect_args)* > > When I tried with regular create_engine, everything worked as expected > with the same database data. > Data in the database (configured for New York) contains timezone info: > > *test | 2021-08-26 16:02:46.057288-04* > > BR, > > Ivan > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/e7f24870-80d0-49f7-99a0-de4d141f33b9n%40googlegroups.com.