> > 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) Before start PostgreSQL on FreeBSD. Set environment variable TZ (time zone). For me work this command: TZ=+00; export TZ or TZ=+00 pg_ctl -o "-i -B 512" -D ....
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных