[plug] Database time fields and DST
brad at wasp.net.au
Sun Mar 25 05:50:22 WST 2007
I'm designing a database. Not a complex one, but a database none the less.
I'm playing in a game where accuracy of timestamps is just a not negotiable, so log searches are
performed in local time and it's pretty important that DST crossings (which may well be variable as
we've seen) are handled smoothly.
I'm planning on making all timestamps in the database GMT but with an extra bit to signify if DST
was active at the time, so in theory all timestamps should translate to local time perfectly
including duplicated times when the clocks roll back.
I'm just fishing for input.. good, bad, ugly? Am I doing something dumb?
I was kinda thinking of encoding it as (time<<1)+DST or similar to keep the format uniform in the
database while not adding extra columns or other silly conversions.
"Human beings, who are almost unique in having the ability
to learn from the experience of others, are also remarkable
for their apparent disinclination to do so." -- Douglas Adams
More information about the plug