Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 avg acr... read more »