RE: date difference (DateDiff) question?

2004-09-09 Thread Cornillon, Matthieu (Consultant)
cfset timeCallPlacedOnHold = queryTmp.HoldDateTime cfset timeOnHoldReleased = queryTmp.ReleasedDateTime For some reason the dates retuned are in this format: Ex: 2004-09-08 12:28:56.0 I can't understand why it adds the .0 after the time when the value stored in the database is 2004-09-08

Re: date difference (DateDiff) question?

2004-09-09 Thread Claude Schneegans
Are your dates in the database date type fields? If yes, the the dates returned in the query are correct. Sometimes, having an _expression_ like -totalDateDiff causes problem with lousy typed ColdFusion. I would suggest you invert the two parameters in dateDiff and forget about the minus sign:

Re: date difference (DateDiff) question?

2004-09-09 Thread Andrew Grosset
Hi, I would guess you're running MX6.1, the zero represents milliseconds... On MX6.1 this will correctly output the difference as 3 seconds. cfset a=2004-09-08 12:28:56.0 cfset b=2004-09-08 12:28:59.0 cfoutput pdifference in seconds=#dateDiff(s,a,b)# /cfoutput Andrew. Hello everybody, I'm