Postgres Pro
Downloads
Home   >   mailing lists

Re: Date Representation Bug. Timezone and update on an already posted as #208 reportbug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Date Representation Bug. Timezone and update on an already posted as #208 reportbug
Date
Msg-id 26293.987777996@sss.pgh.pa.us
Whole thread Raw
In response to Date Representation Bug. Timezone and update on an already posted as #208 reportbug  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> The problem of date representation of 22/05/1977 and 28/05/1978 is
> related with time zone.

What do you get if you coerce the funny dates to timestamp, eg,

    select '22/05/1977'::date::timestamp;

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Date Representation Bug. Timezone and update on an already posted as #208 reportbug
Next
From: Tom Lane
Date:
Subject: Re: Postgresql date bug