Convert Postgres timestamp without timezone to PHP datetime

user_739035 0
Viewed 390

I'm pulling records from a Postgres DB and then saving them to a MySQL DB. I'm fairly new to Postgres and I'm having a difficult time with these timestamps. How can I convert these timestamp without time zone values to a PHP datetime (Central Time)?

enter image description here

utc postgresql mysql php
1 Answers

The DateTime constructor takes a parameter for the timezone. If the constructor can't parse the format you're getting from Postgres, the DateTime class also has a static factory method, DateTime::createFromFormat, in which you can specify the format string as the first parameter.

user_78850810
Related