postgresql7.1.2 select to_char(server.utc_time - timezone__get_offset(timezone__get_id(:user_tz), server.utc_time), :format) from (select timezone__convert_to_utc(tz_id, :timestamp) as utc_time from timezones where tz= :server_tz) server;