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

Eric

Member since Sep 9, 2010

Recent Blog Comments By Eric

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Mar 1, 2011 at 6:50 AM

    I have for years created two columns for all dates (very easy to index). If I have a column named ModifiedDateTime, I will always add ModifiedDate both as dateTime-datatype. Ad DueDate/DueDateTime etc. Then in whatevery frontend, I will create the ModifiedDate as, in this case CF without the time: ... read more »