Redshift support time zones in time stamps from Sep, 2016

[Surgo]

See: Amazon Redshift introduces new data type to support time zones in time stamps

So,

• Redshift can set time zone to session using SET TIMEZONE
• And can create table with TIMESTAMP WITH TIME ZONE fields

[dkarchmer]

Is there a migration path to convert an existing database?

[Surgo]

Maybe no way to migrate using django's migration mechanism. I migrated manually.

[emyller]

Yo @shimizukawa -- can we proceed merging this one? It is highly demanded feature. Thank you. :)

[shimizukawa]

Actually I have no spare time but I'll take a look ASAP.

[emyller]

Hey @Surgo, can you please update the README file at the "Type mapping" section to match the underlying Redshift type? Thanks!

[Surgo]

@emyller Thank you for your comment. updated :)

[shimizukawa]

From now, I check this PR.

[shimizukawa]

I'll merge this PR after resolve conflict. @Surgo can you please rebase?

[Surgo]

@shimizukawa rebased :)

[shimizukawa]

Thanks, I'll merge soon!

On Sun, Aug 27, 2017 at 7:21 PM Kosei Kitahara notifications@github.com wrote:

@shimizukawa https://github.com/shimizukawa rebased :)

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/shimizukawa/django-redshift-backend/pull/23#issuecomment-325189694, or mute the thread https://github.com/notifications/unsubscribe-auth/AAJQR1W6I8v1_iJxtvJOSu6orC6-ANFcks5scUMrgaJpZM4OcU_H .

[shimizukawa]

@Surgo please check this updated README if you have a chance ;) https://github.com/shimizukawa/django-redshift-backend/commit/47d92feb586c1c19a346b18e6666f9ca7c4efd1e#diff-88b99bb28683bd5b7e3a204826ead112

[Surgo]

@shimizukawa thank you for your support!