On Wed, Sep 19, 2018 at 3:51 PM amul sul <sula...@gmail.com> wrote: > > On Wed, Sep 19, 2018 at 2:57 PM Alexander Korotkov [...] > > With this patch, to_date and to_timestamp behaving differently, see this: > > edb=# SELECT to_date('18 12 2011', 'xDDxMMxYYYY'); > to_date > -------------------- > 18-DEC-11 00:00:00 > (1 row) > > edb=# SELECT to_timestamp('18 12 2011', 'xDDxMMxYYYY'); > to_timestamp > --------------------------- > 08-DEC-11 00:00:00 -05:00 <=========== Incorrect output. > (1 row) > Sorry, this was wrong info -- with this patch, I had some mine trial changes.
Both to_date and to_timestamp behaving same with your patch -- the wrong output, we are expecting that? postgres =# SELECT to_date('18 12 2011', 'xDDxMMxYYYY'); to_date ------------ 2011-12-08 (1 row) postgres =# SELECT to_timestamp('18 12 2011', 'xDDxMMxYYYY'); to_timestamp ------------------------ 2011-12-08 00:00:00-05 (1 row) Regards, Amul