Get month from nvarchar column

Question

i have nvarchar column as 4/23/2019 from this i want month 4

Aakash Maurya · Answer

Try SELECT MONTH(CONVERT(NVARCHAR, '4/23/2019', 105)) Working code

Tamal Marick · Answer

If the date format is fixed, like mm/dd/yyyy, then you can try this (without convert). SELECT SUBSTRING('4/23/2019',0,CHARINDEX('/','4/23/2019',0))

Manoj Mandal · Answer

SELECT * FROM H_BABY_MOTHER WHERE MONTH(CONVERT(NVARCHAR,B_DELIVERYDATE,105))='07' this is my query B_DELIVERYDATE is NVARCHAR COLUMN

Amit Mohanty · Answer

Hey try this There are two SQL function to do it: DATEPART() MONTH(). SELECT MONTH ( '4/23/2019' ) [ month ]; OR SELECT DATEPART(MM, '4/23/2019' ) [ month ];

Sonu Gupta · Answer

Hi Manoj, 1. For date format 'mm/dd/yyyy' use this query Your query like this - SELECT * FROM H_BABY_MOTHER WHERE MONTH(CONVERT(DATE,B_DELIVERYDATE))='07' 2. For date format 'dd/mm/yyyy' use this query select MONTH(CONVERT(DATE,'12-01-2019',103))

Aakash Maurya · Answer

Just give me the error text that you are getting. I have SQL version greater than SQL 2008. Error message will help me more

Manoj Mandal · Answer

Akash still it is not working i am using sql server 2008 R2

Chittaranjan Swain · Answer

hi manoj, Try below queries, SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, ), 0) AS [year_month_date_field] FROM or, SELECT YEAR(yourDateField), MONTH(yourDateField), DAY(yourDateField); or, https://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/

Aakash Maurya · Answer

Your query should be like SELECT * FROM H_BABY_MOTHER WHERE MONTH(CONVERT(NVARCHAR,B_DELIVERYDATE,105))=7 Month returns numeric data.

Get month from nvarchar column

Answers (9)