Yeah, I saw that after I posted my response. Thanks!

Nevermind, as I look at it closer, I see your point. Thanks for the correction.

Blessings!

Amber

DECLARE @CurrentDate DATETIME

SET @CurrentDate = GETDATE()

DECLARE @Sample TABLE

(

SomeID INT IDENTITY(1,1)

,SomeDate DATETIME

)

INSERT INTO @Sample

SELECT '2009-04-30 18:29'

UNION ALL SELECT '2009-04-30 10:29'

UNION...

I'm not going to argue with you about this. I've been using dateadd(day, 1, date) for about six months and I use it in many different programs and stored...

Hi Jeff,

The dates I use do have a time with them (that is how SQL stores them) and dateadd(day, 1, date) still works fine.

Thanks!

Amber

I discovered this several months back, but I use: dateadd(day,1,) as my fix. Just another way of doing it.

This is VERY useful information! Thanks for posting...