On Friday, December 30, 2011 8:19:51 am Cezariusz Marek wrote: > > Is the timestamp::text format always the same, regardless of the current > locale and language settings? Now I have an answer. It can be changed via the DateStyle setting in postgresql.conf http://www.postgresql.org/docs/9.1/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT So for my previous setting of (iso,mdy) I got: test(5432)postgres=#select clock_timestamp()::text; clock_timestamp ------------------------------- 2011-12-30 08:56:39.019038-08 Changing the setting to (sql,mdy) resulted in: test(5432)postgres=#select clock_timestamp()::text; clock_timestamp -------------------------------- 12/30/2011 08:55:48.554618 PST -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
