I store the date based upon the timezone the database server sits in. Then for each location I store the timezone information and do date/time differencing when displaying things for the user to see. What I use is a combination of things within Oracle and some ColdFusion. This in turn takes into account DSTs as well as allows me to have a system that should work if the DB ever were to be moved to another timezone for some reason.
On Sun, Jul 26, 2009 at 12:12 PM, Richard White <rich...@j7is.co.uk> wrote: > > yes good point, also there will be users in usa eventually starting to use > it, have you come across this before or seen how others have dealt with > this? > > thanks > > >Richard White wrote: > >> we have a website used in uk. and the server is in usa. > > > >and does DST kick in the same time in your timezone (tz) as it does in the > >server's tz? and will this be the case for the life of the app? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4