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
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:
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
3 matches
Mail list logo