>My understand is that Coldfusion and MS SQL Server 2005 all use the server's >time when using the GETDATE() type functions. Does anyone have any idea why >there would be a discrepancy?
ColdFusion derives its date/time from the JVM. This became an issue last year. If you're running CFMX 7 you'll want to update your JVM to 1.4.2_11 or _13 (I think _13 is supported) to get the fixes for date/time created by the new daylight savings time updates. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
