new template filter to convert datetime from utc to other timezone

[arvin]

I prefer to keep all datetime as UTC in the database as convert them during display.
Attached is a filter to perform this conversion. It assumes that the input datetime
is in UTC. Unfortunately value.tzinfo is not set originally. But I'm not into DB
stuff so I don't know how to change that.

[arvin]

datetime convert filter

[arvin]

A better patch can convert from the TIME_ZONE setting to anther timezone (attached).

But as I've seen in the meantime at least Postgresql can do timezone conversions so
a much better solution would be to simply retrieve the datetime from the database in
the desired timezone. I suppose that would require a timezone setting per session/user
which I'm not up to.

[arvin]

filter to convert between timezones

[enlight]

Replying to arvin:

But as I've seen in the meantime at least Postgresql can do timezone conversions so
a much better solution would be to simply retrieve the datetime from the database in
the desired timezone.

I'm not sure if letting the db do the timezone conversion is necessarily better, it'll be less flexible for sure. A filter seems to me like the best way to go about this.

[Jacob]

This type of conversion ought to be done at the view level, not in a template tag.

[Aymeric Augustin]

This should be resolved by #2626.