search

stripe-archive / mosql

MongoDB → PostgreSQL streaming replication
MIT License
1.63k stars 225 forks source link

Support for TIMEZONEZ column type #116

Open mrfelton opened 8 years ago

mrfelton commented 8 years ago

MoSQL doesn't appear to support the Postgres TIMESTAMPZ date type (otherwise known as timestamp with timezone)

http://www.postgresql.org/docs/9.4/static/datatype-datetime.html

This makes it impossible to include timezone information in date fields currently.

andrewbaker00 commented 8 years ago

@mrfelton Use: created_at: TIMESTAMP WITH TIMEZONE

works for me.