Here is my situation,

tOrders(dtmOrdered datetime)

Alter table tOrders alter column dtmOrdered varchar(26)

when I do this:

2005-01-18 10:34:50.677 is changed to Jan 18 2005 10:34AM, it's not preserving seconds and milliseconds part, I...