How to convert columns to time format?

Question

PostgreSQL

I don't understand how to do it on columns.
1591044532022001 - value from event_timestamp column
1 591 044 464 658 000.00 - value from user_first_touch_timestamp column

Answer 1

https://www.blendo.co/documents/queries-casting-po... .

Answer 2

Try like this:

SELECT 
  to_timestamp(('1591044532022001'::bigint)/1000000) ts1,
  to_timestamp((regexp_replace('1 591 044 464 658 000,00', '[\s,]','','g')::bigint)/100000000) ts2

PostgreSQL fiddle