Home / Questions / 227775
Accepted
Huntzberger
Asked: 2020-01-08 07:24:18 +0800 CST 2020-01-08 07:24:18 +0800 CST

SQL Server DATENAME() Function in Spanish

  • 772

I have these queries but they give me the data in English and I need it in Spanish, is there any way to do that? Thank you

declare @Fecha date
SET @Fecha = GetDate() 
go

DATENAME(day, @Fecha) as Dia, 
DATENAME(weekday,@Fecha) as DiaSemana,  
DATENAME(month, @Fecha) as Mes, 
DATENAME(YEAR, @Fecha) as Año,

Dia DiaSemana  Mes     Año
7   Monday    January  2019

And I need the day and month to be in Spanish

sql-server

1 Answers

  1. Best Answer

    Before executing the function you must specify the language with which you are going to work:

    SET Language 'Spanish';

declare @Fecha date
SET @Fecha = GetDate() 
go

DATENAME(day, @Fecha) as Dia, 
DATENAME(weekday,@Fecha) as DiaSemana,  
DATENAME(month, @Fecha) as Mes, 
DATENAME(YEAR, @Fecha) as Año,

Dia DiaSemana  Mes     Año
7   Lunes    Enero  2019
    • 7