search

PeerDB-io / peerdb

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage
https://peerdb.io
Other
2.25k stars 92 forks source link

mysql: remove WITH TIMEZONE / WITHOUT TIMEZONE syntax from casts #2023

Closed serprex closed 2 months ago

serprex commented 2 months ago

Avoids postgres_fdw enriching queries with syntax MySQL doesn't allow since MySQL timestamps always have tzinfo

DateTime is also the more suitable time type in MySQL, & StarRocks only has DateTime