how to convert string datetime to timestamp in postgreSQL

Question

I have data in a column of string type value.

For example : string value : 20201123043000 i need to get timestamp value : 2020-11-23 04:30:00

How can i write sql query to get above timestamp. Thanks

Answer 1

You can use TO_TIMESTAMP function

SELECT TO_TIMESTAMP('20201123043000','YYYYMMDDHHMISS');