-----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of czezz Sent: Tuesday, May 05, 2015 9:24 AM To: Albe Laurenz Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: RE: display to_timestamp in quotas or convert to char ? Hi, thank you for reply. I have already tried to convert timestamp to char like you suggested but that lead to another error. First, simply execution with NO conversion - to make sure it works like that: Server2=# select to_timestamp('2015-05-04 22:13:14.000', 'YYYY/MM/DD-HH24:MI:SS.FF3'); to_timestamp ------------------------ 2015-05-04 22:13:14+02 (1 row) Secondly, to_char(): Server2=# select to_char(to_timestamp('2015-05-04 22:13:14.000', 'YYYY/MM/DD-HH24:MI:SS.FF3')); ERROR: function to_char(timestamp with time zone) does not exist LINE 1: select to_char(to_timestamp('2015-05-04 22:13:14.000', 'YYYY... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. And this HINT seems to be odd. BR, czezz There is nothing odd about HINT. to_char(timestamp, text) requires second parameter: format, which you didn't provide. Regards, Igor Neyman -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
