Thread: insert of date is wrong
Marcos (tanzarian@bol.com.br) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description insert of date is wrong Long Description when I insert the date '1914/01/01' in a column with the 'date' format, the table returns the value '1913/12/31' Sample Code insert into d values ('1914/01/01'); select * from d; this command return : '1913/12/31' No file was uploaded with this report
pgsql-bugs@postgresql.org writes: > when I insert the date '1914/01/01' in a column with the 'date' format, the table returns the value '1913/12/31' Not for me: regression=# create table foo (f1 date); CREATE regression=# regression=# insert into foo values ('1914/01/01'); INSERT 158325 1 regression=# select * from foo; f1 ------------ 1914-01-01 (1 row) The usual questions ensue: what PG version are you running, on what platform, with what timezone and datestyle settings? regards, tom lane