clear markdown compare help best fiddles feedback dbanow.uk
≡
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. 2805470 fiddles created (40815 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)