Eric
Member since Feb 1, 2012
- Profile: /members/9565-eric.htm
- Comments: 1
Recent Blog Comments By Eric
-
Ask Ben: Averaging Date/Time Stamps In SQL
Posted on Feb 1, 2012 at 1:22 PM
I had issues with the code running against data that overlapped midnight. I adjusted the code which seemed to give more accurate numbers. For instance, if the data was 11PM,1AM,2AM,2AM, you would expect an average around midnight or 1AM. Your math returns 28/4=7 or 7AM. My code breaks when... read more »