Posted by edouard.spooner on 11/03/06 09:18

Hi Boetsid,

I always use dt + 1 because then you're not having to invoke the
dateadd function (which I'm guessing adds overhead).

As dates are stored as numbers anyway within SQL, I dont think you can
go wrong with dt+1, or infact dt-1 or dt+.5 :-)

Ed

boetsid wrote:
> I saw in one of the solutions
> select dt + 1 from #anytable --like ( here dt is a
> datetime field )
> which one is more efficient or robust between
> dateadd(day, 1, dt) -- or only using
> dt + 1

[Back to original message]