change time part

[draganss]

How can I change only the time part of DateTime field?

ex. '2011-01-01 01:00:00' to '2011-01-01 00:00:00'
'2011-01-01 03:45:00' to '2011-01-01 00:00:00'
'2011-02-05 22:01:15' to '2011-02-05 00:00:00'

Thank you

 

[r937]

UPDATE daTable
SET datetimecol =
DATEADD(day,DATEDIFF(day,0,datetimecol),0)

straight outta

http://www.tek-tips.com/faqs.cfm?fid=5842

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[draganss]

Thank you!!!

 

[Qik3Coder]

my lazy answer for this is:

UPDATE daTable   
SET datetimecol = [b]left(datetimecol,11)[/b]

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]