webrunner,

.786 isn't a valid millisecond for the datetime datatype...

All datetimes end in either .xx0, .xx3 or .xx7

.xx9, .xx0 and .xx1 are rounded up/down to .xx0

.xx2, .xx3, .xx4 are rounded up/down to .xx3

.xx5, .xx6, .xx8 are rounded up/down to .xx7

Check out the BOL "Date and Time" for an example table.

Thanks,

Chad