Joachim Wieland <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq