On Wed, Mar 3, 2010 at 1:46 PM, Ian Skinner <[email protected]> wrote: > To expand on Micheal's answer. You have to be careful of the datediff() > result as it always rounds *DOWN*. Thus if you are asking for the > difference in days between two date time objects that are 9 days, 23 > hours and 59 minutes apart, the function will return a value of 9.
Except that 3/13/2010 00:00:00 and 3/15/2010 00:00:00 are exactly 2 *days* apart down to the second. Because of the daylight savings time change over on the 14, it just so happens that those two dates are 47 hours apart. Does anyone know what unit CF changes the datetime down to in order to do comparisons? Milliseconds? And is this something that is an issue with Java or with CF? Because I would certainly call it a bu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
