remove/null out time portion of date 1

[password99]

how do i update the time portion of date column to be null in a update statement?

e.g. before 12/09/2004 23:20:06:357

after the update should be 12/09/2004 00:00:00

 

[dbomrrsm]

This will flatten the time

select dateadd(dd, datediff(dd,0,'12/09/2004 23:20:06:357'),0)

[blue]DBomrrsm[/blue]

 

[maswien]

same idea,

select dateadd(dd, datediff(dd, '01/01/2004', dateColumn), '01/01/2004') from Mytable