Hi Andre,

Can you please try the following SQL Convert DateTime operation. If you check the given reference link, you will see that the convert options 3 and 4 will also work for your case just like option 5 in the below example.

declare @dt datetime = getdate()
select @dt, replace(convert(varchar(20),@dt,5),'-','')

I hope that helps,