Our DB and web servers are all in the same time zone, but there is code where I had to get the data from the database, because I couldn't trust my Linux admins to keep the correct system date on the Linux web servers. It really screwed up the company turn times when someone would complete their work "tomorrow"! :)
~Brad -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 06, 2006 2:01 PM To: CF-Talk Subject: Re: Old code woes This is good and bad example. You may want the date in the DB with an offset with multiple webservers in a follow the sun approach write to a single DB in one location. A call to GetDate in this instance would lead to the same date/time for each you may not want. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
