- Original Poster
- #1
What I am trying to do, I have two fields in a table, both datetime type, i want to find out the average time between the two in hours.
something like this:
select avg(magic_date_function(date1, date2)) from table
but with a less fictional function for working out the number of hours between two dates. looked in manual but cant find anything
something like this:
select avg(magic_date_function(date1, date2)) from table
but with a less fictional function for working out the number of hours between two dates. looked in manual but cant find anything
