SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.tbltemp(Dia DATETIME);
INSERT INTO dbo.tbltemp(Dia)
VALUES ('20170320'),
       ('20170321'),
       ('20170322'),
       ('20170323');
4 rows affected

SET Language 'Spanish';


SELECT  Dia,
        LEFT(DATENAME(WEEKDAY,Dia),3) + ' ' +
        CONVERT(VARCHAR(10),Dia,105) Dia_Formateado
FROM dbo.tbltemp; 


Dia
Dia_Formateado


2017-03-20 00:00:00.000
Lun 20-03-2017

2017-03-21 00:00:00.000
Mar 21-03-2017

2017-03-22 00:00:00.000
Mié 22-03-2017

2017-03-23 00:00:00.000
Jue 23-03-2017


Se cambió la configuración de idioma a Español.


SET Language 'Spanish';

SELECT Dia,
       FORMAT(Dia, 'ddd dd-MM-yyyy') Dia_Formateado
FROM dbo.tbltemp; 
       


Dia
Dia_Formateado


2017-03-20 00:00:00.000
lu. 20-03-2017

2017-03-21 00:00:00.000
ma. 21-03-2017

2017-03-22 00:00:00.000
mi. 22-03-2017

2017-03-23 00:00:00.000
ju. 23-03-2017


Se cambió la configuración de idioma a Español.

Dia	Dia_Formateado
2017-03-20 00:00:00.000	Lun 20-03-2017
2017-03-21 00:00:00.000	Mar 21-03-2017
2017-03-22 00:00:00.000	Mié 22-03-2017
2017-03-23 00:00:00.000	Jue 23-03-2017

Dia	Dia_Formateado
2017-03-20 00:00:00.000	lu. 20-03-2017
2017-03-21 00:00:00.000	ma. 21-03-2017
2017-03-22 00:00:00.000	mi. 22-03-2017
2017-03-23 00:00:00.000	ju. 23-03-2017