Skip minutes from date and time field

make it smalldatetime if you dont want beyond minute precision

Declare

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

Declare

@Datasdt smalldatetime='2014-10-16 12:10:45.000'


Select

@Data,Convert(smalldatetime,@Data) as converted,@Datasdt as direct

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page