what day of month today

1.get the first day and last day of the month.echo Date (' y-m-01 ', Strtotime ('-1 month '));echo "";echo Date (' Y-m-t ', Strtotime ('-1 month '));echo "";2.get the first day of the month and the last day.$BeginDate =date (' y-m-01 ', Strtotime

MySQL queries a lot of ways, the following for you to introduce the MySQL query is to query this week, last week, this month, the last month's data, if you are interested in MySQL query, may wish to see.Query the current data todaySELECT

---the first day of the current weekSelectCONVERT (varchar ( -), DATEADD (day,-(DATEPART (Weekday,getdate ())-1), GETDATE ()), at) as'Monday', CONVERT (varchar ( -), DATEADD (day,-(DATEPART (Weekday,getdate ())-7), GETDATE ()), at) as'Sunday',--this

SELECT * FROM table WHERE convert (Nvarchar, DateAndTime, 111) = CONVERT (Nvarchar, GETDATE (), 111) ORDER by DateAndTime DESCRecord of the Month SELECT * FROM table WHERE DateDiff (Month,[dateadd],getdate ()) =0 Week

Select date_sub (now (), interval 1 month) current time of last month today select unix_timestamp (date_sub (now (), interval 1 month) current time of last month today (timestamp) select date_sub (date_format (now (), '% Y-% m-% d 08:00:00'),

Show the starting and ending points of this month, last month, today, and this yearThe mktime () function returns the Unix timestamp of a date.The parameter always represents the GMT date, so is_dst has no effect on the result.The parameters can be

: This article describes how to obtain the number of days of the current month, the first and last days of the current month, the first day of the previous month, and the last day of the previous month. if you are interested in the php Tutorial,

This is the SQL script that calculates the first day of the one month:SELECT DATEADD (mm, DATEDIFF (Mm,0,getdate ()), 0)--the first day of the monthSELECT DATEADD (mm, DATEDIFF (Mm,0,getdate ())-1, 0)-the first day of the monthSELECT DATEADD

Small Talk: The first day of the new year to work, looking at the end of their 15 years writing code, really feel very bad, because there is no time to write at the end, a thought to do backstage management need to get a week start and end date,

Code:#include #include #include using namespace std;int hashmapping (int mouth) {vector days{31,28,31,30,31,30,31,31,30,31,30,31}; return days[mouth-1];} int isleapyear (int year, int mouth) {if ((year%4 = = 0 && year%100! = 0) | | (year%400 = =