SQL or ColdFusion?: Determine length of time to take a survery
Posted on 2004-09-24
I am putting together a survey. I'm capturing the datetime when the person starts the survey (startDateTime) and the datetime they finish (endDateTime).
I want to be able to calculate the length of time each person took, as well as determine average time to complete.
I'm using the following code:
select Datediff(ss, startDateTime, endDateTime) as secDiff
This will give the response in seconds which I can calulate into minutes:seconds.
Does this seem correct or is there another way that's better?