title: How to validate time in sql server?
body: <p>I have a value "27:30" as a varchar. I want to cast this value in time.
  like.... CAST('27:30' AS Time) OR CONVERT('27:30', TIME).</p>
  
  <p>But it gives error. </p>
  
  <p>How can I convert it?</p>