rkonopka (12/17/2008)
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
I've started to use that approach for time stripping but this article was written before I adopted that method. Thanks for the input!