Fecha
1/12

SELECT FORMAT(GETDATE(),'dd/MM') Fecha;

SELECT DATENAME(DAY,GETDATE()) + '/' + CONVERT(VARCHAR(2),MONTH(GETDATE())) Fecha
;

SELECT CONVERT(VARCHAR(5),GETDATE(),103) Fecha;

SELECT CONCAT(MONTH(GETDATE()), '/', Day(GetDate())) as Fecha

SELECT CAST(Day(GetDate()) AS VARCHAR(10) ) +'/'+ CAST(MONTH(GETDATE()) AS VARCHAR(10)) as Fecha

SELECT (CONVERT(varchar(3),DAY(GETDATE()))+'/'+ CONVERT(varchar(3),MONTH(GetDate()))) as Fecha

SELECT CONVERT(VARCHAR(5),GETDATE(),103) AS FECHA

SELECT CONVERT(VARCHAR(5),GETDATE(),101) AS FECHA

SET LANGUAGE Spanish
SELECT CONCAT('día ', DAY(GETDATE()), ' mes ', DATENAME(month, GETDATE()))