Re: Bug with timestamp !!! (resolve)
Started by Alexander Dedereralmost 25 years ago1 messagesgeneral
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 ....