Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jason Dean and Simon Free and Alison Huselid and Josh Adams and John Mason
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jason Dean@JasonPDean ) , Simon Free@simonfree ) , Alison Huselid , Josh Adams@jladams97 ) , and John Mason@john_mason_ )

landon humphrey

Member since Dec 11, 2008

Recent Blog Comments By landon humphrey

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

    Posted on Feb 22, 2007 at 3:21 PM

    Here is my code. Works okay but the last = statement returns an error. How to I compare the newreportdate and the JustTheDate values. I have tried many maybe to many ways. Thanks Landon SELECT reportdate,worktype, maintby, CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )as timeret, CONVERT... read more »