Recently by the date made a lot of headaches, because the month of JS is more special [0-11], so in the months of many difficult to calculate. Specially sorted out the date some methods.
First of all, the following code has a common date format
Obtain the day of a month, the day of the month, and the day of the month.[Javascript]Var Nowdate = ("2012-11-22"). split ("-"), // obtain a dateNowYear = parseInt (Nowdate [0]), // a yearNowMonth = parseInt (Nowdate [1]), // a monthNowday =
C # example: write a program to test the standard height and weight, input the date year month day, calculate the day of the year (considering the leap year ),
I. switchStatement exercise example
// Compile a program to test the standard height and
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
: 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,
Mysql queries data from the current day, this week, this month, and the previous month.
Today
Select * from table name where to_days (time field name) = to_days (now ());
Yesterday
SELECT * FROM table name WHERE TO_DAYS (NOW ()-TO_DAYS (time field
There are a few doubts about datetime and time.1, Datetime.datetime.now ()--Why two DateTime is required to return the current time, only need to Time.localtime ()And then I got it. Datetime.datetime.now ()--The first datetime is the name of the Py
//TodayDateTime.Now.Date.ToShortDateString (); //yesterday, it was today's date minus one.DateTime.Now.AddDays (-1). ToShortDateString (); //tomorrow, in the same vein, add aDateTime.Now.AddDays (1). ToShortDateString (); //This week, knowing
PS: After learning Regular Expressions for so long, I didn't make any decent patterns. I woke up early and came up with a whimsy, I made up my mind to prove that my regular expression is not white-so I chose the most common date match ......
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.