|
|
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
Navigation:
[Reply to this message]
|