Community Member Profile
I P
Member since Jan 27, 2011
- Profile: /members/7679-I-P.htm
- URL: NA
- Comments: 1
- Points: 11
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 16... read more »
