[afiori]

The problem is that nobody does it, for example no DB (AFAIK) does it, they all store dates as something like a Unix timestamp.

And for a lot of things problems would be solved with +01:00 offset while for others you actually want Europe/Berlin offsets

[ldng]

Europe/Berlin is NOT an offset, it's the zone. A proper date needs BOTH the offset AND the zone ! How come people don't understand timezone when it's right there, in the etymology of the word !?

Sorry not personal but I find myself explaining that each time the subject comes up at work (and generally to the same people... sigh)

[rjh29]

Postgres supports timezones. In general Postgres is excellent for correctness at the cost of performance.

[leni536]

unix timestemp is unaffected by DST

[int_19h]

Postgres and Oracle has TIMESTAMP WITH TIME ZONE. MSSQL has DateTimeOffset.