Convert Date to year / month

Question

I was able to convert the date to year / month, but I need the date to go like this: 2019/04, but it’s coming out like this: 2019/4

how can I fix this?

SELECT CONVERT(VARCHAR(4), DATEPART (year,'01/04/2019')) + '/' + CONVERT(VARCHAR(4),DATEPART(month,'01/04/2019')) as AnoMes

Answer 1

Try

-- código #1
SELECT convert (char(7), nome_coluna, 111) as AnoMes
  from tabela;

where column name is stated as date, datetime or some other type of data specific to date storage.
Style 111 refers to the format 'yyyy/mm/dd'.

Example:

-- código #2
declare @data date;
set @data= convert (date, '1/4/2019', 103);  -- dd/mm/aaaa

SELECT convert (char(7), @data, 111);

Answer 2

Try it this way:

    select format(CAST('04/01/2019' AS DATE), 'yyyy/MM');

That test I did had to date it as 'MM/dd/yyyy'.

Answer 3

SQL provides some ready time and date conversions, here is a tabelinha: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

As the link, could be being done so:

SELECT CONVERT(CHAR(7), GETDATE(), 111) AS [ANO/MES]
FROM TABELA

The return pattern when you do CONVERT(VARCHAR, DATA, 111) is 'YYYY/MM/dd', replacing SWEEP for CHAR(7) it will return the first 7 characters: 'YYYY/MM'