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


Member since Jan 27, 2011

Recent Blog Comments By I P

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

    Posted on Jan 27, 2011 at 9:01 AM

    i have query of sql 2005 Select Truck_No,Report_No, Convert(Varchar,Rep_Date,05) As "RDate" From RecTruck Where Rep_Date Between Convert(Varchar,'2010-11-01',05) And Convert (Varchar,'2010-11-30',05) And Trk_Frm='AHMEDABAD' Result of 20Rows AP13X4130 163 01-11-10 AP13X1370 164 02-11-10... read more »