select CONVERT(numeric(18,4),getdate(),101);

Update Table set datecolumn = CONVERT(numeric(18,4),datecolumn,101);

Note

First take backup your database and test it on sample data first then come to production Server