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.

Thanks for any advice.