Re: How to convert US date format to European date format ?

[John R Pierce <pierce@xxxxxxxxxxxx>]

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