Update only date against datetime field

Question

Viewing 4 posts - 1 through 4 (of 4 total)

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

sturner SSC-Insane Points: 22411 More actions · Answer 1

declare @x datetime -- this is your date time column or variable

set @x = getdate() -- set it to current time value

select @x -- display current value

set @x = convert(char(10),@x,101) + ' 01:01:01' -- set time to a new value

select @x --display new datetime value

---- sorry, I must be dyslexic. You wanted to change the date not the time:

set @x = '2010-01-01 ' + convert(char(12),@x,114) -- set new date value, same time

select @x -- display new value

The probability of survival is inversely proportional to the angle of arrival.

t-sql-hero Grasshopper Points: 18 More actions · Answer 2

Have a similar solution using dateadd and datediff.

declare @d datetime

set @d = '2010-04-04'

update dateupdate set [date] = DATEADD(dd, DATEDIFF(dd, [date], @d), [date]) where id = 1

Regads,

muralikrishna-484408 SSC Enthusiast Points: 176 More actions · Answer 3

SSC Enthusiast

Points: 176

March 12, 2010 at 10:53 am

Thanks Alot dude...:-)

Cookies on SQLServerCentral