SV: to_timestamp function

2019-03-21 Thread Gustavsson Mikael
Thanks for fast reply! I'll forward the answer to my developers. kr Mikael Gustavsson Från: Tom Lane [t...@sss.pgh.pa.us] Skickat: den 20 mars 2019 17:33 Till: Gustavsson Mikael Kopia: pgsql-general@lists.postgresql.org Ämne: Re: to_timestamp fun

Re: to_timestamp function

2019-03-20 Thread Tom Lane
Gustavsson Mikael writes: > So my question is, is it intentional that to_timestamp is stricter than cast > to timestamp? Yes. The point of using that function at all is to be strict about the input format, so being strict about the field values seems to make sense along with that. An independe

to_timestamp function

2019-03-20 Thread Gustavsson Mikael
Hi, We recently upgraded from PG9.6 to PG11 and I have some questions regarding the function to_timestamp. We have an application that for some reason unknown to me uses timestamps with hour = 24. After upgrade we got som problems with this. The solution is to use cast instead of the function