[thelist] MSSQL: adding integer to time yields date?

Canfield, Joel JCanfield at PacAdvantage.org
Mon Nov 28 10:41:04 CST 2005


> You can do this in MSSQL using DATEADD. The vbscript function 
> to do the same
> thing is also called DATEADD

Exactly what I'm doing. Why does smalldatetime plus int equal a date?

joel



More information about the thelist mailing list