datetime - Sql server update zero value existing date -


i have date value 2017-09-18 11:27:59.547 table.

how can l update 2017-09-18 00:00:00.000 on records?

can give me sql script?

this should trick

update table set field = cast(field date); 

Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -