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