Look this: create table tmp (create_date timestamp); #insert into tmp values('2001-04-01 02:29:52'); INSERT 1021715 1 #select * from tmp; create_data ------------------------ 2035-05-29 01:33:36-05 (1 row) ! ! ! ! It's work on FreeBSD 4.2. PostgreSQL install from: postgresql-7.1.1.tar.gz postgresql-base-7.1.1.tar.gz postgresql-opt-7.1.1.tar.gz ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl