Isn't that: April 8th, 2010 / 19 hours 41 minutes 36 seconds April 12th, 2010 / 19 hours 10 minutes 34 seconds
Around 3 days, 28 minutes, 58 seconds apart? (No coffee yet, so results may be skewed!) And what does the first decimal place in "36.0" represent, anyway? A tenth of a second? Never worked with time and decimal places. -----Original Message----- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Tuesday, April 13, 2010 9:09 AM To: cf-talk Subject: Re: DateDiff() and Minutes Wierdness Um, aren't those times like 50 seconds or so apart? Isn't 50 seconds < 1 minute? Therefore 0 "full" minutes? On Tue, Apr 13, 2010 at 7:32 AM, Bradley Stone <b...@nb9m.com> wrote: > > All: > > Feeding DateDiff() dates which are more than 24 hours apart yields minutes: > > <cfoutput> > #DateDiff("n", "2010-04-08 19:41:36.0", "2010-04-12 19:10:34.0")# > </cfoutput> > > Result: 5728 > > However, feeding DateDiff() dates which are LESS than 24 hours apart yields nothing: > > <cfoutput> > #DateDiff("n", "2010-04-08 19:34:47.0", "2010-04-08 19:35:35.0")# > </cfoutput> > > Result: 0 > > What am I missing? Any help appreciated! > Brad Stone > Benchmark Technologies Inc. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm