Additional Column in date format

Hi 

I have a copy activity 

Source=MySql DB

Target=SQL Server Azure 

On my source I have added an additional Column using this expression:

@formatDateTime(utcNow())

but the resulting target tabel in the SQL Server is Nvarchar(max()) - that a string. 

I set the sink side up to crate the table if not exist and I drop the tabel every time I run the flow. 

Can you help me out? 

Regards, 

Christian