As the question states i tried
UPDATE mytable set end_date="2015-07-17 22:00:00+00" WHERE id=8244;
But this does not work for obvious reasons, all the detail on the web is about searching for dates not updating them, especially when they have timezones
The timestamptz datatype is a time zone-aware date and time data type. PostgreSQL stores the timestamptz in UTC value. When you insert a value into a timestamptz column, PostgreSQL converts the timestamptz value into a UTC value and stores the UTC value in the table.
UPDATE mytable set end_date='2015-07-17 22:00:00+00' WHERE id=8244;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With