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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/0696b293-89f1-4527-82de-6a1fd5e2393bn%40googlegroups.com.