On 4/10/2013 12:35 PM, Thomas Kellerer wrote:
> But the *display* is done by the client.
> And if Postgres (the server) did the conversion, I would not be able
> to see a different date formatting in e.g. a JDBC based tool. So I
> guess psql is reading that database/server setting.
psql is letting postgres send it as text rather than the binary internal
date format.
JDBC has its own extensive date munging with its own database
independent rules. in particular, it does NOT use libpq.
--
john r pierce 37N 122W
somewhere on the middle of the left coast