Sql2k hasn't date type field but datetime,

is there any simple meanings to display & edit a datetime field

as date field in an textbox ?


If the answer is no.

I gonna write a function to change type of all datetime field
in a view/spt cursor, with a parameter tcExcept_field_list