Python polars write database Time zone issue

[Sankartk]

Checks

• I have checked that this issue has not already been reported.
• I have confirmed this bug exists on the latest version of Polars.

Reproducible example

Hi, I have a question about the Python polars write_database method. I am having a parquet file with a date time column with value as 2024-08-08 18:03:05.012 EDT. When using the write_database method, the data is getting written as 2024-08-08 17:03:05.012. The database Time zone is set as America/New_York. Similarly for the same date time when I want to store as a date, in the parquet is getting correctly transformed as 2024-08-08 00:00:00 EDT but it is getting written as 2024-07-08 in the dayabase. The database is Aurora Postgres. Is there any work around for this ? Please let me know.

Log output

Issue description

Hi, I have a question about the Python polars write_database method. I am having a parquet file with a date time column with value as 2024-08-08 18:03:05.012 EDT. When using the write_database method, the data is getting written as 2024-08-08 17:03:05.012. The database Time zone is set as America/New_York. Similarly for the same date time when I want to store as a date, in the parquet is getting correctly transformed as 2024-08-08 00:00:00 EDT but it is getting written as 2024-07-08 in the dayabase. The database is Aurora Postgres. Is there any work around for this ? Please let me know.

Expected behavior

Expected behavior is to write the time as is from parquet file

Installed versions

Polars version 1.4.1