Method 1: obtain the number of days in the current month.
untitled document
Method 2: traverse the number of days of each month in a year
untitled document
Method 3: determine the number of days in a certain year of the month.
How do I calculate the day of the week? --Caille (Zeller) formulaWhat is the day of the week in history? What day of the week is the future? There are a number of computational formulae (two general calculation formulae and some piecewise
I. Basic Principles
1. weighted average method. It is also called once every month. this means to calculate the weighted average unit cost of inventory by removing the total purchase cost of the current month and the inventory cost at the beginning
To the company found that there is a report not received, after viewing the original is an Oracle data source exception. select to_char (sysdate - interval " Span style= "color: #ff0000;" > ' 1 " , yyyymmdd " ) as Fromdata, To_char (sysdate -
Copy codeThe Code is as follows :/*
| Author: Yang Yu
| @ Param char | int $ start_date is a valid date format, for example, 20091016,2009-10-16.
| @ Param char | int $ end_date same as above
| @ Return the number of weekend days between a given
All along, the most used is my97datepicker to get the month and day method, today suddenly wandered to this article, stay, for future use
Write one yourself: Get the year and start counting from next month
Original reproduced from:
Bat obtains the previous month.If you want to back up the last month's files at the beginning of each month, you need to obtain the last month's Month. Note that the last month of July is July, in addition, the result of reducing the number by 1 for
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 ......
Simulation implementation date Perpetual calendar, including date plus minus days, date minus date, calendar that can output a certain year month includes its own implementation constructor, copy constructor, operator overloading, and other default
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
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.