Popular Posts

4/18/2018

What Day and Time Is It

How do you track time in the database.

You could base off the timestamp of the web user, which could vary drastically across the globe and different time zones.  You could determine their time zone and subtract Greenwich Time Zone as an offset.

You could base off the time zone where the server resides, except if its in the Cloud across multiple locations, then what.  You could base the time off the store that a person is physically in at the time of transaction.  How about call centers, could be in variety of locations across the country or globe or span multiple time zones.

What time is it.  What day is it.  These seem like easy questions, yet the more you dig into it, the solution varies greatly and requires a systematic consistent architecture that spans the globe.

And so it goes~!