• In your view change the select for the column you want changed to

    cast( <column> as datetime)



    Shamless self promotion - read my blog http://sirsql.net