Surendra Sharma
Showing posts with label Get date part from datetime field in sql stmt. Show all posts
Showing posts with label Get date part from datetime field in sql stmt. Show all posts
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
Subscribe to:
Posts (Atom)