How to updte time in datetime, please help me

Question

How to updte time in datetime, please help me

vantuan02t1

Mr or Mrs. 500

Points: 598
More actions
March 26, 2012 at 10:21 pm

#253727

Hello every one,
I have data type datetime:
theDate
2012-03-27 11:12:33.073
2012-03-27 12:11:33.075
2012-03-27 13:10:33.076
I want update field theDate to:
theDate
2012-03-27 00:00:00.000
2012-03-27 00:00:00.000
2012-03-27 00:00:00.000
Help me, please.
Thank you very much.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Instead of just telling you, how about I point you at one reference that may help you with some of what you are trying to accomplish:

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

vantuan02t1 Mr or Mrs. 500 Points: 598 More actions · Answer 2

vantuan02t1

Mr or Mrs. 500

Points: 598

March 26, 2012 at 11:08 pm

#1464706

Thank you very much, I have done it. 🙂

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Okay, glad to hear it. Now, you on the other hand, should post the code you wrote to solve your problem. It may help someone else who may have a similar problem, plus it is proper forum etiquette.

okbangas SSChampion Points: 11773 More actions · Answer 4

Personally, I find a cast more clean code, I have not done any performance testing though to see if it is performing any differently than dateadd/datediff:

declare

@dt datetime;

select @dt = cast(getdate() as date)

select @dt

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]

vantuan02t1 Mr or Mrs. 500 Points: 598 More actions · Answer 5

Hi every one, this is my solution.

update table_name

set theDate = dateadd(dd, datediff(dd, 0, theDate), 0)