How to update a datetime field with timezone in postgresql

Question

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

Mike 'Pomax' Kamermans · Accepted Answer · 2023-03-28 17:28:30Z

27

Postgres is a little different in that single and double quotes do wildly different things.

Double quotes are used to denote identifiers or keywords
Single quotes denote regular strings

So the fix here is to make sure to use single quotes:

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

edited Mar 28, 2023 at 17:28

Mike 'Pomax' Kamermans

54.3k17 gold badges134 silver badges182 bronze badges

answered Jul 20, 2015 at 8:56

Ispirer SQLWays Migrations

1,0589 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr Mixin Over a year ago

oh so the double quotes were the problem

Ispirer SQLWays Migrations Over a year ago

Yes. Double quotes are usually used to specify the delimited identifiers in the database. This is how they are defined in most of RDBMS.

Collectives™ on Stack Overflow

How to update a datetime field with timezone in postgresql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related