ALTER TABLE [FIES].[T_MO_PARAMETER_ITEM] ADD [EditDate] datetime NULL
GO
update mpi
set mpi.[EditDate] = cast(cast(cast(GETDATE() as int) as float) as datetime)
from [FIES].[T_MO_PARAMETER_ITEM] mpi
GO
ALTER TABLE [FIES].[T_MO_PARAMETER_ITEM] ALTER COLUMN [EditDate] datetime NOT NULL
GO