Kris Jurka wrote:
I initially thought this was a great idea, but it breaks down when they don't use a PreparedStatement and generate a query directly, then we can't intervene and adjust things. The advantage of setting the server to the client's timezone is that this will work as expected.
What about the {ts ...} etc escapes for time/date values? Aren't you meant to use those for the case where you have literal date values in the query?
-O