I have a database table that has 2 columns. defined as datetime, length of 8.
the column/data looks like :
tir_start - 1/1/1900 2:38:52 PM
tir_end - 1/1/1900 2:39:37 PM
there are many rows per day..the day date is another column.
I need to determine the avg time between the start and end column for many rows.