Postgre returns wrong values for varchar-timestamp conversion : I have been encountering a very strange error while working on a postgre server. I have a column which contains times as varchar in the format HH24MMSS and I have to convert it to a timestamp using to_timestamp(varchar, 'HH24MMSS'). However, it returns me wrong values and I cannot understand why. Here are a few examples:

    Select to_timestamp('111111', 'HH24MMSS')

-> 11:00:11

    Select to_timestamp('000000', 'HH24MMSS')

-> 00:00:00


    Select to_timestamp('122317', 'HH24MMSS')

-> 12:06:49

Here A Short Overview:

[enter image description here][1]


  [1]: https://i.stack.imgur.com/5H3q1.png


Unfortunately, I cannot offer more detailed information about the server since I am not the admin nor the one maintaning it. I only know that it is Postgre 9.2. I really do not understand, what is wrong here. I would appreciate any hint or help. 