1 ORACLE mid-week related knowledge description 1.1 Date formatting functions To_char (X [,FORMAT]) : Press X toFORMATThe format is converted into a string. X is a date,FORMATis a format string that specifies the format in which X is
How to calculate the day of the week?Slowtiger published on 2009-11-19 08:42:00How to calculate the day of the week?--Caille (Zeller) formulaWhat is the day of the week in history? What day of the future is the week? With regard to this problem,
--Caille (Zeller) formulaWhat is the day of the week in history? What day of the future is the week? With regard to this problem, there are many computational formulae (two general formulas and some piecewise formulas), the most notable of which is
Obtain the date range of the week based on the time range of the week.Obtain the date range of the week according to the week
/*** Return the range of Weekly Times of a month in a certain year * @ param weeks Weekly Times * @ return the range of
Obtain the date of a week based on a week of a year. For example, if the start date is set to "Thursday" to "Friday" of the next week, you can refer to the following requirements when getting the JS date: Obtain the date of the week based on a week
First, use your formula to compile a simple program:
Main ()
{Int year;/* year */
Intw;/* day of the week */
Scanf ("% d", & year );
W = (year-1) + (year-1)/4-(year-1)/100 + (year-1)/400 + 1) % 7;
Printf ("% d \ n", W );
Getch ();
}
Enter 1 during
Common date Operations
/**
* Get the start date of all weeks of the year
* @param $year format ' YYYY '
* Returns the two-dimensional array subscript key1 value corresponds to the actual year of the week of the year Key2
Transferred from: http://www.cnblogs.com/likwo/archive/2010/04/16/1713282.htmlQuery Day:SELECT * FROM table where to_days (column_time) = To_days (now ());SELECT * FROM table where date (column_time) = Curdate ();Query one week:SELECT * FROM table
Query Day:Select * from Table where = To_days (now ()); Select * from Table where =Query one week:Select * from Table where 7 Day Date (column_time);Query one months:Select * from Table where 1 MONTH Date (column_time);MySQL date and time
I test, useful, relatively strong applicability, directly on the code to speak.Package Com.hellobike.data;import Java.text.parseexception;import Java.text.simpledateformat;import Java.time.dayofweek;import Java.time.instant;import
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.