SQL Server - Get Date or Time From Date Time Column / Field in SQL Server 2008 / 2005

Here I will explain SQL Server query to get only date or time from date time field in SQL Server2008 or 2005 or how to get only date or time from current date time field in SQL Server 2008 / 2005.

Description

In previous articles I explained sql server get list of procedures which contains table name, SQL Server difference between view and stored procedure, SQL Server difference b/w LEN and DATALENGTH functions and many articles relating to SQL Server. Now I will explain how to get only date or time from date time field in SQL Server.

We can get date or time in different formats from date time field using different styles. Now I will display different format of dates with samples check it 

DECLARE @DateTime DATETIME  SELECT @DateTime = '2010/05/20 11:21:13' /*For mm/dd/yyyy format*/ Select CONVERT(VARCHAR(10),@DateTime ,101) as Date /*For yyyy.mm.dd format*/ Select CONVERT(VARCHAR(10),@DateTime ,102) as Date /*For dd/mm/yyyy format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,103) AS Date /*For dd.mm.yyyy format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,104) AS Date /*For dd-mm-yyyy format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,105) AS Date /*For hh:mi:ss format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,108) AS Date /*For mm-dd-yyyy format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,110) AS Date /*For yyyy/mm/dd format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,111) AS Date /*For yyyymmdd format*/ SELECT CONVERT(VARCHAR(10),@DateTime ,112) AS Date