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

Storing dates as strings is a major design bug. You should be looking for ways to replace that string field with a proper date field. If this is a new application, simply fixing the bad type would be enough and no conversion would be needed — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Nov 24, 2020 at 8:17

Barbaros Özhan · Accepted Answer · 2020-11-24 08:18:19Z

2

You can use TO_TIMESTAMP function

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

user330315

answered Nov 24, 2020 at 8:16

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1