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

Mark Rees mrees at itsagoodprice.com
Mon Nov 28 10:30:38 CST 2005

> I'm trying to use a smalldatetime field as my starting time and an int
> field as the length in hours to calculate the ending time of an event
> using VBScript in ASP.

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



More information about the thelist mailing list