I would have thought most hosting companies would have their servers set to UTC ( or Greenwich Mean Time) . Is that not true?
I have servers in California, but ours are on UTC so we can move them from place to place if we choose and it makes no difference to the code. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jul 30, 2010 at 12:02 PM, Charlie Griefer <charlie.grie...@gmail.com > wrote: > > I -think- it's 2k8, but based on my discussion with the previous developer, > I'm not sure database tweaks are going to do it. > > I've pitched Andy's trigger idea to the client. Still waiting to hear > back... > > On Thu, Jul 29, 2010 at 6:55 PM, Maureen <mamamaur...@gmail.com> wrote: > > > > > Which version of SQL Server, because timezone data is handled > > differently between 2005 and 2008, and if it is 2008 you could likely > > fix this issue with some database tweeks. > > > > On Thu, Jul 29, 2010 at 12:29 PM, Charlie Griefer > > <charlie.grie...@gmail.com> wrote: > > > > > > Hey Scott: > > > > > > Hmm... not sure that the current site will run under Railo. Also, > their > > > current database is SQL Server (I probably should have mentioned that). > > > Looks like Alurium is exclusively Railo/mySQL ( > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm