clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044263 fiddles created (9444 in the last week).

CREATE TABLE dbo.tbltemp(Dia DATETIME);
 hidden batch(es)


INSERT INTO dbo.tbltemp(Dia) VALUES ('20170320'), ('20170321'), ('20170322'), ('20170323');
4 rows affected
 hidden batch(es)


SET Language 'Spanish'; SELECT Dia, LEFT(DATENAME(WEEKDAY,Dia),3) + ' ' + CONVERT(VARCHAR(10),Dia,105) Dia_Formateado FROM dbo.tbltemp;
Dia Dia_Formateado
20/03/2017 00:00:00 Lun 20-03-2017
21/03/2017 00:00:00 Mar 21-03-2017
22/03/2017 00:00:00 Mié 22-03-2017
23/03/2017 00:00:00 Jue 23-03-2017
Se cambió la configuración de idioma a Español.
 hidden batch(es)