Hi, Something is pretty broken in redhat 7.3 but I'm not sure what and I don't have time to dig further
masm@test=# select cast('1967-04-18' as timestamptz); timestamptz ------------------------ 1967-04-17 18:00:00-06 (1 row) masm@test=# select cast(cast('1967-04-18' as date) as timestamp); ERROR: Unable to convert date to tm masm@test=# Both cases works correctly in Redhat 7.2. Sorry if this is not the correct forum however an alert is nice for people planning an Redhat upgrade. I hope to see pretty soon an update since I don't want to downgrade my server. Regards, Manuel. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org