To select date from datetime in MSSQL you can use the following snippet.
Sample MSSQL
SELECT CONVERT(VARCHAR(10),Testdatecolumn,104) FROM dbo.tblTest
The 104 is for tt.mm.jjjj, a list of formats can be found at the MSDN CAST and CONVERT (Transact-SQL)
RT @CodeSnippetsNET: How to select date from datetime in #MSSQL http://t.co/S3WqjkC0W8 #sql #programming #code #coding #dev