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

Terry Collinson

Member since Jan 9, 2012

Recent Blog Comments By Terry Collinson

  • Using MySQL's TO_DAYS() Function To Group Same-Day Events

    Posted on Jan 9, 2012 at 8:12 AM

    I just cannot get anything to work for me - using SQL2000. I just want to sort a record set by the date/time field event date but then group by date. SELECT eventdate as ??????? FROM FieldEventNotes WHERE region = '#region#' GROUP BY eventdate??? order eventdate desc Spent hours on this... read more »