Surendra Sharma

Surendra Sharma

Search This Blog

Tuesday, May 4, 2010

To get only date part from datetime field in sql stmt.

CAST(CONVERT(varchar(100), dbo.Attendance_Detail.Attendance_Date, 101) AS datetime) AS Attendance_Date

No comments:

Post a Comment