Return date as ddmmyyyy or any other format in SQL Server

Notice that use upper case MM to get month lower case mm will return minutes instead

SELECT FORMAT(GETDATE(), 'ddMMyyyy')

https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15