title: Time format hhmm to hh:mm sql server 2005
body: <p>I want to find the time difference so i am trying to use <strong>DATEDIFF</strong> option.
  But the problem is i am having the time values in hhmm format(eg: 1715). So it showing out of range error. so i want to convert it to hh:mm format. How to convert hhmm to hh:mm format?</p>