title: need to Show time in HH:MM format only
body: <p>i declare a field as <strong>time</strong> in sql. it is storing the date in the format as <strong>HH:MM:SS</strong>. now i want to retrieve the time value in the format <strong>HH:MM</strong>  and show it on the design view. is it possible to show time only in HH:MM? if so how to cast it as <strong>HH:MM</strong> format?</p>