'how do I change 2019-01-14T22:45:07+0100 to 2019-01-14 22:45:07 in Postgres? It is Facebook data stored in a text format
I want to change the date formats in PostgreSQL from the first instance to the second example in the code below.
2019-01-14T22:45:07+0100
to
2019-01-14 22:45:07
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|