Safari
Reputation: 11945
ISO 8601 format date for PostgreSQL
I have string containing an ISO 8601 formatted date-time value (ex: 2013-05-21T15:00:00+0200) and time zone (ex: Europe/Rome).
What is the best Postgres data type to represent this date format?
Upvotes: 8
Views: 19654
Answers (1)
Pavel Stehule
Reputation: 45900
Type "timestamp with time zone" is what you want.
http://www.postgresql.org/docs/current/static/datatype-datetime.html
Upvotes: 9
Related Questions
- Turn postgres date representation into ISO 8601 string
- postgres cast | convert interval to iso_8601 format
- DateTime format in PostgreSQL?
- Is there any way to get Postgres to use proper ISO 8601 timestamps globally and automatically?
- Postgres time zones and formatting
- how to create ISO-8601 gregorian date table in postgres
- PostgreSQL: SET TIME ZONE formatting
- PostgreSQL - how to render date in different time zone?
- Postgresql date formatting
- How to format "time with time zone" in Postgres?