GitHub

Question: Converting timestamp long value into string literal datetime expression

I'm trying to set up a realtime migration pipeline using Debezium + kafka-connect-jdbc sink connector. There is an issue in converting MySQL's DATETIME(6) column into PostgreSQL's TIMESTAMP type ...
GitHub

Update/Insert Timestamp doesn't work with PostgreSQL SQL syntax.

Update/Insert Timestamp doesn't work with PostgreSQL SQL syntax. It throws exception as "org.postgresql.util.PSQLException: ERROR: value is not a timestamp: invalid value provided" That would be the ...
LinkedIn

Spark SQL from_unixtime() returns string not timestamp

I spent an hour debugging a query. The values were correct. The timestamps looked right. Nothing crashed. It was still returning wrong results. The change that caused it looked minimal. Before: ...
LinkedIn

Oracle Timestamp Binds Not Captured.

Being an Oracle performance expert you always be dealing with lot of queries. While doing SQL tuning of a query, it is quite common that we ask application team what binds are being used or else we ...