i want to update date field but i am getting error like update ... update emp set date_t = convert(datetime,'2006-03-31 19:56:36.933456') Srinika.
www.sqlteam.com