Home Forums Article Discussions Article Discussions by Author Discuss content posted by Seth Phelabaum Date Manipulation with DATEADD/DATEDIFF RE: Date Manipulation with DATEADD/DATEDIFF
nakache
Mr or Mrs. 500
Points: 503
More actions
April 6, 2010 at 11:07 pm
#1147017
the fastest way to remove time from datetime is:
select CONVERT(datetime,floor(convert(float,getdate())))
Itzik Ben-Gan had a big post on Date Manipulation with benchmarking..(long time ago..)