How to update datetime field with timezone in postgresql

As the question says, I tried

UPDATE mytable set end_date="2015-07-17 22:00:00+00" WHERE id=8244;

      

But it doesn't work for obvious reasons, all the details on the internet are about finding dates that don't update them, especially when they have time slots

+3


source to share


1 answer


UPDATE mytable set end_date='2015-07-17 22:00:00+00' WHERE id=8244;

      



+5


source







All Articles