Get month only from datetime field in database

Question

How can I get the month value from database field? For example: My database is like that DatabaseA(Id Name CreatedTime Notes) I want to get month value only of CreatedTime from DatabaseA . Thank you for viewing my question.

Sonu Chaudhary · Answer

dear Their are 2 ways to get month from date its depend on you which you actually want. 1.Only month number such as 123..Then you need to use Datepart Example :- SELECT DATEPART(month creationDateTime) FROM [Table_Test] 2. Month name such as Jan Feb Mar... then you need to use DateName Example :- SELECT DATENAME(month creationDateTime) FROM [Table_Test]

Praveen Kumar Sreeram · Answer

I assume DatabaseA is your table name. You can use the following. Select DATEPART(mmcreatedTime) from DatabaseA Please note that createdTime should be of a valid SQL Server date datatype. Hope it helps Prawin