SQL Server (T-SQL) Date only from DateTime field 01 August 2013 Admin SQL Server If you want only the abortion in america Date part of the DateTime field there are many ways of doing this however the best abortion pill nyc method I can find is the following:- SELECT DATEADD(dd, 0, DATEDIFF(dd,0, GETDATE())) as DateOnly