How to get the month and current year in SQL?

Question

How can I print the current month and year on the screen in sql ? I need the month to be extended. I’m using the query below.

select GETDATE() from DUAL

Currently it is being printed as follows.

2018-08-21 10:34:03.253

I need it printed in the form below:

August - 2018

Answer 1

Use the DATENAME. See a example

SELECT DATENAME(month, GetDate())   + ' de ' +  DATENAME(year, GetDate())

Note: DATENAME applies to: SQL Server (SQL Server 2008 up to current version), Database Windows Azure SQL data (initial version until current version). Source: https://msdn.microsoft.com/pt-br/library/ms174395(v=sql.120). aspx

Answer 2

Try it like this:

    select 
    case month(getdate())
        when  1 then 'Janeiro'
        when  2 then 'Fevereiro'
        when  3 then 'Março'
        when  4 then 'Abril'
        when  5 then 'Maio'
        when  6 then 'Junho'
        when  7 then 'Julho'
        when  8 then 'Agosto'
        when  9 then 'Setembro'
        when 10 then 'Outubro'
        when 11 then 'Novembro'
        when 12 then 'Dezembro'
    end + ' - ' + cast(year(getdate()) as varchar(4))
 As MesAno

Answer 3

Script to return a full date.

SET LANGUAGE Português

SELECT DATENAME(weekday, GetDate()) + ', '   +
       DATENAME(day, GetDate())     + ' de ' +
       DATENAME(month, GetDate())   + ' de ' +
       DATENAME(year, GetDate())

Remember to use the SET LANGUAGE to return the date in the desired language, to check the default language of your run session DBCC UserOptions

To view what is the name of existing languages in SQL check in the table name column sysLanguages.

select * from master.dbo.syslanguages

Note: Avoid using SET LANGUAGE within procedures as this will cause RECOMPILE.

Answer 4

   select convert(char(02),(getdate()),101)