Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ENH/SQL: support writing timestamps with timezone in to_sql #9086

Closed
jorisvandenbossche opened this issue Dec 15, 2014 · 2 comments

Comments

Projects
None yet
5 participants
@jorisvandenbossche
Copy link
Member

commented Dec 15, 2014

This currently works a bit for datetime values in the index (not in the columns, reason for this is that is then are object columns: #9085).
I say 'a bit', as it does give a 'timestamp with time zone' type (example for postgresql), but it is the time localized in your local timezone (I suppose because this is the way numpy works on input/output of datetimes).

In any case, also the code here (https://github.com/pydata/pandas/blob/v0.15.2/pandas/io/sql.py#L916) is not working (as columns never have a tzinfo attribute), and there are also no tests for this.

So in practice, timezones are not yet supported.

@ieow

This comment has been minimized.

Copy link

commented Oct 22, 2016

Hi,
any update on the timezone issue?

@oliveratutexas

This comment has been minimized.

Copy link

commented Jun 13, 2018

Also curious for updates!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.