I have a
datetime2 field that I need to be a
datetime field. If I try to run an
Alter Table statement my SSMS session freezes and I have to force reboot with no change made, if I try to alter my design view of the table I get an error about needing to drop/re-create the table.
Which leads me to my question, if I have a field that is
datetime2 if I
Add Column helper1 datetime how could I set the default value of this column to
dt2 which is a
datetime2 data type?