Getting only Month and Year from SQL DATE

let's write it this way: `YEAR(anySqlDate)` and `MONTH(anySqlDate)`. Try it with `YEAR(GETDATE())` for example.

My database doesn't support most of the functions above however I found that this works:

<code>SELECT * FROM table WHERE SUBSTR(datetime_column, starting_position, number_of_strings)=required_year_and_month;</code>

for example:
<code>SELECT SUBSTR(created, 1,7) FROM table;</code><br>

returns the year and month in the format "yyyy-mm"

There are two SQL function to do it:

* [DATEPART()](

[To see links please register here]

)
* [YEAR()](

[To see links please register here]

) and [MONTH()](

[To see links please register here]

).

Refer to the linked documentation for details.

SELECT convert(varchar(7), getdate(), 126)

You might wanna check out this website:

[To see links please register here]

***Get Month & Year From Date***

DECLARE @lcMonth nvarchar(10)
DECLARE @lcYear nvarchar(10)

SET @lcYear=(SELECT DATEPART(YEAR,@Date))
SET @lcMonth=(SELECT DATEPART(MONTH,@Date))

SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-')

Output: Mar-2019

Query :- `Select datename(m,GETDATE())+'-'+cast(datepart(yyyy,GETDATE()) as varchar) as FieldName`

Output :- January-2019

general datefield we can use

datename(m,<DateField>)+' '+cast(datepart(yyyy,<DateField>) as varchar) as FieldName

For result: "YYYY-MM"

SELECT cast(YEAR(<DateColumn>) as varchar) + '-' + cast(Month(<DateColumn>) as varchar)

select convert(varchar(11), transfer_date, 106)


got me my desired result of date formatted as 07 Mar 2018


My column 'transfer_date' is a datetime type column and I am using SQL Server 2017 on azure

CONCAT (datepart (yy,DATE), FORMAT (DATE,'MM'))

gives you eg 201601 if you want a six digit result