====== CONVERT date formats ====== Some common ''CONVERT'' date formats for use in: CONVERT(VARCHAR(20), date_value, style) ^Date format ^ ''style'' ^ |dd/mm/yyyy | 103 | |dd mon yyyy | 106 | |yyyymmdd | 112 | |yyyy-mm-dd hh:mi:ss | 120 | {{tag> tsql functions}}