Home > mailing lists

Re: to_timestamp() and timestamp without time zone - Mailing list pgsql-general

From	hernan gonzalez
Subject	Re: to_timestamp() and timestamp without time zone
Date	June 23, 2011 17:06:26
Msg-id	BANLkTi=bqcb==6+K1rTeBt7AOgZHbGPVtA@mail.gmail.com Whole thread Raw
In response to	to_timestamp() and timestamp without time zone (hernan gonzalez <hgonzalez@gmail.com>)
List	pgsql-general

Tree view

There is some related discussion here

http://postgresql.1045698.n5.nabble.com/to-timestamp-returns-the-incorrect-result-for-the-DST-fall-over-time-td3327393.html

But it amounts to the same thing: TO_TIMESTAMP() is not apt for dealing with plain TIMESTAMP

(without time zones).

Hence, there is no fiable way of parsing a "local date time", using this function, I must resort to

workarounds as defining a new function that internally sets, for example, set LOCAL timezone = 'UTC'

Hernán J. González

pgsql-general by date:

From: Merlin Moncure
Date: 23 June 2011, 16:41:09
Subject: Documented conversion from PostgreSQL->MongoDB...then right back to PostgreSQL :-)

From: Steve Crawford
Date: 23 June 2011, 18:25:45
Subject: Re: to_timestamp() and timestamp without time zone

Re: to_timestamp() and timestamp without time zone - Mailing list pgsql-general

Previous

Next