Re: TODO-Item: full timezone names

Joachim Wieland <joe@mcknight.de> writes:
> With a timetz it's more tricky, because "America/New_York" does not specify
> a timezone offset by itself, this could change due to daylight savings time
> for example. So my idea was to apply whatever offset is valid in this region
> at the moment of parsing the string representation.

You can't be serious.  The correct interpretation of
    '2006-06-01 10:49 America/New_York'
has to be 10:49 in whatever time was then in use in New York.  Not when
you read the string.

            regards, tom lane