Skip minutes from date and time field

Chek This out,

Declare

@Data Datetime = '2014-10-16 12:10:00.000'

Select

@Data , Convert ( Varchar ( 16 ), @Data , 120 )

---

Please have look on the comment