Results 1 to 4 of 4
Thread: DB in different time zone
Jan 24, 2005, 19:44 #1
- Join Date
- Mar 2002
- Fishers, IN USA
- 0 Post(s)
- 0 Thread(s)
DB in different time zone
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.