Re: Why does Django create Postgres timestamp columns with time zones?

>From >postgresql.org/docs/8.4/static/datatype-datetime.html: > "All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the timezone configuration parameter

Re: Why does Django create Postgres timestamp columns with time zones?

It's not required by PostgreSQL. See, http://www.postgresql.org/docs/8.4/interactive/datatype-datetime.html , for example. You may be able to change the data type of that column directly in the database. (See http://www.postgresql.org/docs/8.4/interactive/ddl-alter.html#AEN2595 .) Maybe

Why does Django create Postgres timestamp columns with time zones?

I thought that Django created datetime columns that were time zone agnostic, but when I looked at my Postgres table I saw that the values recorded there have time zone information. Going further I found that the Postgres backend directs Django to create columns that use time zones. >From