DATEDIFF (intervalstring, date1, date2) Ole Dyring February 17, 2021 07:38 Returns an integer corresponding to the difference according to intervalString between date1 and date2. Valid intervals are d,dd,w,ww,m,mm,q,y,yy,yyyy,h,hh,n,s See also: DATEADD, DATEFIFFMILLISECOND, DATEPART, DATESERIAL
Valid interval should be enclosed in single quotes, e.g.:
datediff('hh', StartTime, StopTime)
Please sign in to leave a comment.