SQL Server (T-SQL) Date only from DateTime field 1. August 2013 Admin SQL Server (0) 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