Re: to_timestamp() and timestamp without time zone

From: hernan gonzalez <hgonzalez(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: to_timestamp() and timestamp without time zone
Date: 2011-06-23 17:05:59
Message-ID: BANLkTi=bqcb==6+K1rTeBt7AOgZHbGPVtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-06-23 17:48:04 Re: PostgreSQL 8.4.8 bringing my website down every evening
Previous Message Merlin Moncure 2011-06-23 16:41:01 Documented conversion from PostgreSQL->MongoDB...then right back to PostgreSQL :-)