I have a database and web server that are located in a different time zone than the one I'm in. I'm building a site that is focused on local topics, so I'd like to make sure I always display the correct local time on items such as comments, document release dates, etc.
My question is this: At what tier should I do my time zone shift?
- At the business/application tier as the data is entered so that it is stored as "my time" in the database?
- At the data tier as the data is requested (via stored procedures, etc.)?
- At the business/application tier as the data is presented to the user?
For whatever reason, I'm having a hard time deciding which option is best as I can see advantages/disadvantages to all three options.