No problem, John. Timezones is always a tricky challenge to have.
Look at it this way, if your host server will always be in NJ... and you (and ALL your users) will always be in HI, then its as easy as calculating everything using DateAdd. When you post a timestamp with now() on a database record, that is NJ timezone minus 6 hrs for HI users. But as your website grows, not all of your users will be in HI. And chances are, you might even move your host to a different timezone. So, then the problem you'll have is 'What are you going to do with your data that has all the NJ timestamps?'. Do you see the problem now? That is why it is important to use UTC zone to store your datetime data (instead of your server's datetime timezone). If and when you need to change something on your server, or deal with different user timezones, your not stuck in thinking about converting everything from NJ's time. > -----Original Message----- > From: John Barrett [mailto:[EMAIL PROTECTED] > Sent: Monday, August 11, 2008 12:11 AM > To: CF-Newbie > Subject: Re: server time > > Hi Michael, > thanks so much for your help. I will look into this. > I looked and HI time is UTC-10. > > Thanks and I will let you know how this works out. > John > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3916 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
