Timezone handling ================== All the timestamp type values (Area.ctime, Item.ctime, Revision.ctime) are in UTC and stored in the database as such. In Postgresql this is using timestamp type, and in sqlite is using a ISO string format (without time zone). On retrieval from database, postgresql does it automatically, and for sqlite we do a conversion from string using mx.DateTime.ISO.ParseDateTime(x). This ensures that the values read are in UTC. Only in the client (cfv/cfvadmin) they are converted to local time for display only. This at least ensures that timestamps are consistent and their display is chosed by the client (using its timezone); the drawback is that it loses the original time zone.