3 ms·
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 problem
by afiori 4y ago
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
- rjh29 4y agoPostgres supports timezones. In general Postgres is excellent for correctness at the cost of performance.
- ldng 4y agoEurope/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)
- leni536 4y agounix timestemp is unaffected by DST
- int_19h 4y agoPostgres and Oracle has TIMESTAMP WITH TIME ZONE. MSSQL has DateTimeOffset.