SQLSERVER DATE FORMATS SAMPLES

CONVERT(VARCHAR(10), aaa, 101) +' ' + CONVERT(VARCHAR(8), aaa, 108) AS ACTION_DATE ,

o/p :-09/20/2018 10:36:00

IIF(CONVERT(INT, col) = 0, 

    CONVERT(VARCHAR(2), DAY('2014-05-17')) + '/' + 

    CONVERT(VARCHAR(2), MONTH('2014-05-17')) + '/' + 

    CONVERT(VARCHAR(4), YEAR('2014-05-17')), 

    CONVERT(VARCHAR(2), DAY(col)) + '/' + 

    CONVERT(VARCHAR(2), MONTH(col)) + '/' + 

    CONVERT(VARCHAR(4), YEAR(col))) AS DATEC