Skip to main content
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Simeon Bateman
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Simeon Bateman@simBateman )

Eric

Member since Feb 1, 2012

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 »