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 ...

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: ...

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 ...