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


Member since Dec 11, 2008

Recent Blog Comments By Dimonytch

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

    Posted on Feb 27, 2007 at 2:14 PM

    Landon, you can solve your problem with the nested select: select * from (SELECT reportdate,worktype, maintby, CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )as timeret, CONVERT(nvarchar(20), GETDATE(), 102) AS JustTheDate, CONVERT(nvarchar(20), reportdate, 102) AS newreportda... read more »