Viewing 2 posts - 1 through 2 (of 2 total)
Which type is Field1. Try with DT_DBTIME2
September 25, 2010 at 2:23 am
#1227340
SELECT DateDiff(ms, CONVERT(TIME, '00:00:00', 108), CONVERT(TIME, '0:01:04.50', 114)) / 1000.0
September 24, 2010 at 1:58 pm
#1227217