I have a table, that has a unix timestamp field for start and end of a process.
I have seen a number of suggestions that appear to calculate averages unsing Datediff, but as I am using unix timestamps, this isn't necessary, is it?
I can calculate the time difference for each entry (end-start) but how can I calculate an average of all of these differences across the entire data set?
starttime) AS length FROM
complete = '1'
But the value it returns is negative, and so I am thinking that I have got this all wrong.