Seems I have been very sheltered for the last 13 years of developing software systems. For the first time in my life I have to implement a system that spans multiple time zones.
I have done quite a bit of googling and reading up on the topic, but my head seems more confused, not less, as a result.
The server / database is in 1 time zone.
The clients / browsers are in one or more different timezones.
Each client must see their date times in their own time zone.
One solution; store everything on the server in UCT, store each user's timezone, and dynamically transform for each request .
Then there is the whole SQL 2008 datetimeoffset type, and corresponding .Net DateTimeOffset, but that is messing with me.
I know this is not a Naked Objects specific problem, but it seems to complicate the issue. How do I display / store the dates across time zones with NOF?
I'm hoping I am missing some really straight forward mechanism. This is such a pervasive requirement in the world and it must have been solved in a simple way that takes the pain out of it.