CODEWITHSUNDEEP
postgresql
Neo
Neo

Reputation: 81

Trying to understand PostgreSQL Date/Time format

In my PostgreSQL database I see date/time values like

2013-08-08 14:35:50-07
2014-02-20 01:57:59-08

Can someone please let me know what is that suffix 07 & 08 stand for?

thanks.

Upvotes: 1

Views: 67

Answers (2)

Pieter21
Pieter21

Reputation: 1845

ISO-8601 offset for PST: See documentation: (http://www.postgresql.org/docs/current/static/datatype-datetime.html)

Upvotes: 1

Konstantin V. Salikhov
Konstantin V. Salikhov

Reputation: 4653

Those are timezone offset. 2014-02-20 01:57:59-08 means 1:57 AM in Pacific Time Zone

Upvotes: 1

Related Questions