Skip to main content
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: James Allen
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: James Allen@CFJamesAllen )

Frank Hilliard

Member since Dec 11, 2008

Recent Blog Comments By Frank Hilliard

  • Ask Ben: Averaging Date/Time Stamps In SQL

    Posted on Aug 11, 2006 at 6:35 PM

    I really appreciated your info on this because it was through using your CAST to FLOAT (or DECIMAL) and back out again as TIMESTAMP that I realized CF has this built in to the AVG function. Just AVG a list of dates and use DATEFORMAT on the output side and you'll get the same thing. :)... read more »