On Wed, Sep 19, 2018 at 3:51 PM amul sul <sulamul@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