Get ddyyyy Format from DateTime column in SQL Server

Hi telldurges, 

Refer below Sql query.

DECLARE @Test AS TABLE([Date] DateTime)
INSERT INTO @Test VALUES('04-11-2019')

SELECT RIGHT('0' + CAST(DATEPART(DAY,CONVERT(VARCHAR(10),[Date],103)) AS VARCHAR(2)), 2)
+ CAST(DATEPART(YEAR,CONVERT(VARCHAR(10),[Date],103)) AS VARCHAR(4)) AS TodayDate FROM @Test

OUTPUT

Date

042019