Extracting Date from DateTime field in SQL Server

Extracting Date from DateTime field in SQL Server


SELECT CONVERT (varchar(8), , 1) AS DATE FROM


change the values of 3rd argument as 1, 2, 3, 4 etc you will get diffrent date format
Source:-
http://www.sql-server-helper.com/tips/date-formats.aspx
http://www.fmsinc.com/free/NewTips/SQL/SQLTip2.asp