Now() polls the server running CF system's clock time, getDate() does the same except on the box that hosts the SQL Server. My assumption is any difference between the two would be the result of the two server's clocks not being in sync. This can happen if the servers do not make use of a central time server to keep their clocks synced, clocks on normal computers and servers are not known for being scientifically accurate over long periods of time.
Are you able to log into the servers and confirm that their system time is the same? Of course, this assuming you have two separate servers... =] On Tue, May 18, 2010 at 1:56 PM, Sean N Henderson <[email protected]>wrote: > > Over the past few years the drift between now() and getDate() has grown > to almost 10 minutes. Using CFMX6.1 (J2RE 4_2_11), Win2K3 and SQL2K. > > What's the tweak/fix or where should I look? (Besides upgrading to newer > software stack) > Have poured over the CF Admin and Enterprise Manager to no avail. > > Would be swell to shrink the difference back under 2 minutes or closer. > TIA -S > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
