How to use C # and SQL to obtain the first and last days of the current month

How to use C # and SQL to obtain the first and last days of the current month

Post ed on wind reading (233) Comments (0) EDIT add to favorites category: work experience, Asp.net Body: 62.5, beforecate: 78.125, total: in daily development, we often need to determine whether the time is within the current month
C # int year = datetime. Now. Year;
Int month = datetime. Now. month;

Datetime firstdayofthismonth = new datetime (year, month, 1 );
Datetime lastdayofthismonth = new datetime (year, month, datetime. daysinmonth (year, month ));

Sqldeclare @ now datetime
Declare @ fistdayofthismonth datetime
Declare @ lastdayofthismonth datetime

Set @ now = getdate ()
Set @ fistdayofthismonth = @ now-day (@ now) + 1
Set @ lastdayofthismonth = dateadd (month, 1, @ now-day (@ now) + 1)-1

Select @ fistdayofthismonth
Select @ lastdayofthismonth