Thread

Re: Bug with timestamp !!! (resolve)

Alexander Dederer <dederer@spb.cityline.ru> — 2001-05-13T05:26:21Z

> > 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 ....