Introduction
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.