Need SQL Query

Thank you for your reply.

But, I need it in SQL. Please let me know if you can wirte in SQL.

Thanks

Hi,

void DateTest()
{

DateTime date1 = new DateTime(2007, 8, 10);
DateTime date2 = new DateTime(2007, 9, 11);

DateTime dateStart = new DateTime(date1.Year, date1.Month, 1);
DateTime dateEnd = new DateTime(date2.Year, date2.Month, DateTime.DaysInMonth(date2.Year,date2.Month));

TimeSpan difference = dateEnd.Subtract(dateStart);

MessageBox.Show(difference.Days.ToString());

}

Regards,
Jan