Re: Difference in TO_TIMESTAMP results.

2018-09-18 Thread Andrew Gierth
> "Prabhat" == Prabhat Sahu writes: Prabhat> postgres[114552]=# select to_timestamp('15-07-84 23:30:32','dd-mm- Prabhat> hh24:mi:ss'); Prabhat> to_timestamp Prabhat> -- Prabhat> 0084-07-15 23:30:32+05:53*:28* Prabhat> (1 row) Prabhat> My doubt

Re: Difference in TO_TIMESTAMP results.

2018-09-18 Thread Alexander Korotkov
On Tue, Sep 18, 2018 at 8:44 AM Prabhat Sahu wrote: > > I have found below difference in TO_TIMESTAMP results. > > postgres[114552]=# select to_timestamp('15-07-1984 23:30:32','dd-mm- > hh24:mi:ss'); >to_timestamp >

Difference in TO_TIMESTAMP results.

2018-09-17 Thread Prabhat Sahu
Hi All, I have found below difference in TO_TIMESTAMP results. postgres[114552]=# select to_timestamp('15-07-1984 23:30:32','dd-mm- hh24:mi:ss'); to_timestamp --- 1984-07-15 23:30:32+05:30 (1 row) postgres[114552]=# select to_timestamp(&#x