I have a column »timestamp with time zone«. I want to extract the date/time in a different format including the time zone offset in a query but without seconds. If I do
select to_char(datetime, 'YYYY-MM-DD HH24:MI') from table; then the time zone offset is missing in the output: 2011-03-25 18:01 If I do select date_trunc( 'minute', datetime) from table; then the time zone offset is present, but the seconds are not removed: 2011-03-25 18:01:00+01 I want it to look like this: 2011-03-25 18:01+01 How to do that? Marco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
