Home Forums Article Discussions Article Discussions by Author Discuss content posted by CheeseMan316 Useful Dates: The Many Uses of Date Tables RE: Useful Dates: The Many Uses of Date Tables
rkonopka-828284
Grasshopper
Points: 19
More actions
December 17, 2008 at 8:24 am
#913873
Instead of double converting (first to varchar then back to datetime), wouldn't it be simpler and "cleaner" to do this:
select dateadd(dd,datediff(dd,0,getdate()),0)
Enjoyed the article