Postgresql – Convert text column with timestamp literals in non-standard format to timestamptz
I am getting raw data from a customer which I am loading into a db using a script. As of now, I am storing everything as strings. I have data in this format: 18.02.2024 00:06:09.125. I want to convert the…