| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | "Abraham\, Danny" <danny_abraham(at)bmc(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general\(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: day interval |
| Date: | 2019-10-12 20:27:11 |
| Message-ID: | 15267.1570912031@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> "Abraham" == Abraham, Danny <danny_abraham(at)bmc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abraham, Danny | 2019-10-13 07:50:57 | RE: Re: day interval |
| Previous Message | Andrew Gierth | 2019-10-12 18:51:57 | Re: SELECT d02name::bytea FROM ... && DBI::Pg |