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

[Mark Rees]

> 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

Cheers

Mark