On 06/02/2011 03:15 AM, Paolo Saudin wrote:
Trying to convert unix time to date time format, I encountered a database
crash.
This is a known issue, and will be addressed in the next beta. Detail
from an earlier post by Tom Lane:
Tom Lane wrote:
> This is the known problem with timezone abbre
Trying to convert unix time to date time format, I encountered a database
crash.
Environment : WINDOWS 7 Professional - Service Pack1
--
-- PostgreSQL 8.4.7, compiled by Visual C++ build 1400, 32-bit
--
SELECT to_timestamp(1306760400);
2011-05-30 15:00:00+02
--
-- PostgreSQL 9.1beta1, compiled
