Re: day interval - Mailing list pgsql-general

From Tom Lane
Subject Re: day interval
Date
Msg-id 15267.1570912031@sss.pgh.pa.us
Whole thread Raw
In response to Re: day interval  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> "Abraham" == Abraham, Danny <danny_abraham@bmc.com> writes:
>  Abraham> The problem is still this:
>  Abraham> select date('20191001') - date('20190101') ;
>  Abraham> in my servers it is always '273'.
>  Abraham> In the customer's DB it is '273 days';

> Then you need to establish why that is.

I recall having heard that EDB installs some non-PG datetime operators
to make things act more similar to Oracle.

            regards, tom lane



pgsql-general by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: SELECT d02name::bytea FROM ... && DBI::Pg
Next
From: "Abraham, Danny"
Date:
Subject: RE: Re: day interval