On mån, 2012-05-21 at 15:34 +1000, Brendan Jurd wrote: > I'd be okay with just adding a note in the manual under Date/Time > Output to the effect of "Note: ISO 8601 specifies the use of uppercase > letter 'T' to separate the date and time. Postgres uses a space for > improved readability, in line with other database systems and RFC > 3339."
But that is wrong. We use the space because SQL says so. The reason we have all those other formats is for readability or consistency or some secondary standard. But the format of the ISO format is exactly what the SQL standard says, without any other considerations. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
