The problem is that a type cast from timestamp (without time zone) and timestamp with time zone depends on the current setting of the parameter timezone. So if you say that the query "breaks" on one system (whatever exactly that means), the parameter must be set differently in the respective sessions.
Laurenz Albe
- 257k
- 22
- 312
- 388