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

[Joshua Olson]

> -----Original Message-----
> From: Canfield, Joel
> Sent: Monday, November 28, 2005 4:45 PM
> 
> But, I still have my original question: how does one add four hours to
> eight in the evening, using values from a MSSQL table and VBScript?

Joel,

Same way as you are currently doing it.  Just don't rely on the
day/month/year in the result unless the original time includes a
day/month/year portion.  :-)

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 
Fax: 413.812.4864

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/