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~!
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Data becomes information. Information adds value if used properly to align business practices, streamline processes with net result of incr...
Data is the new oil. Sort of a good analogy. Except new oil is constantly required. And there is only so many oil wells on the planet. A...
What do you want to do when you grow up. For some of us, we still haven't decided. After close to 50 years. Chances are, if you chos...