How to get month in datetime field in database using C#

[Neo]

To get month as a number,

Code: Select all

int theMonth = ((System.DateTime)yourDateTimeFieldObject).Month;

To get month as a string like November, December....

Code: Select all

int theMonth = ((System.DateTime)yourDateTimeFieldObject).ToString("MMMM");

[Neofriend]

Or the way I've came to solve this issue is by using an excellent method namely DATEPART - very convenient and does all the work for you.