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
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
Comments
Valid interval should be enclosed in single quotes, e.g.:
datediff('hh', StartTime, StopTime)
Please sign in to leave a comment.