BUG #12367: Wrong result on to_char() when inputing dates

From: Israelins85(at)yahoo(dot)com(dot)br
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12367: Wrong result on to_char() when inputing dates
Date: 2014-12-29 03:12:18
Message-ID: 20141229031218.8013.51171@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12367
Logged by: Israel
Email address: Israelins85(at)yahoo(dot)com(dot)br
PostgreSQL version: 9.3.5
Operating system: MacOs/Windows/Linux
Description:

this select shows the diference:

SELECT
to_char(('2014-12-28 22:01:39.151-03' AT TIME ZONE 'UTC'),
'IYYY-MM-DD"T"HH24:MI:SS.MS"Z"'),
to_char(('2014-12-28 22:01:39.151-03' AT TIME ZONE 'UTC'),
'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2014-12-29 06:30:46 Re: BUG #12328: can't install the postgresql
Previous Message David G Johnston 2014-12-29 01:04:04 Re: Rollback on include error in psql