Skip site navigation (1) Skip section navigation (2)

Re: insert of date is wrong

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tanzarian(at)bol(dot)com(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: insert of date is wrong
Date: 2001-07-25 06:52:44
Message-ID: 20311.996043964@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-07-25 07:23:41
Subject: Re: pg_dump doesn't handle CREATE FUNCTIONs well
Previous:From: Tom LaneDate: 2001-07-25 06:45:07
Subject: Re: real or float4 '=' operator is broken in 7.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group