adding and subtracting hours and minutes

Java time processing (Continued ) Learning to calculate basic time periods in Java Overview If you know how to use date in Java, it is not as easy to use time as it is. This article tells you how to link their differences. This article is based on (

-- Start Java uses the date class to represent the date and time. Since JDK 1.1, most of the methods in the date class are no longer recommended because these methods cannot meet international requirements. instead, the calendar class is used to

MySQL Date time function encyclopedia1. DAYOFWEEK (date)The return date is the day of the week (1= Sunday, 2 = Monday,...... 7= Saturday, ODBC Standard)Mysql> Select DAYOFWEEK (' 1998-02-03 ');32. WEEKDAY (date)The return date is the day of the week

Oracle and Mysql time formatting 1. Oracle formatting time: Oracle obtains the current date and Date Format Get system date: SYSDATE () format Date: TO_CHAR (SYSDATE (), 'yy/MM/DD HH24: MI: SS) or TO_DATE (SYSDATE (), 'yy/MM/DD HH24: MI: SS) format

In php, if we get another date by adding or subtracting a few days from a date, we will use two instances to indicate that the time is converted to the timestamp by strtotime and mktime and then processed, if you need it, check it out. Example:

DAYOFWEEK (date)The return date is the day of the week (1= Sunday, 2 = Monday,...... 7= Saturday, ODBC Standard)Mysql> Select DAYOFWEEK (' 1998-02-03 ');3WEEKDAY (date)The return date is the day of the week (0= Monday, 1 = Tuesday,...... 6=

DAYOFWEEK (date)The return date is the day of the week (1= Sunday, 2 = Monday,...... 7= Saturday, ODBC Standard)Mysql> Select DAYOFWEEK (' 1998-02-03 ');3WEEKDAY (date)The return date is the day of the week (0= Monday, 1 = Tuesday,...... 6=

String functions1.ASCII (str)Returns the ASCII value of the first character of the string str (str is empty when the string returns 0)SELECT ASCII (' 2 ');->502.ORD (str)If the string str first is a single byte, returns the same value as the ASCII ()

DAYOFWEEK (date)The return date is the day of the week (1= Sunday, 2 = Monday,...... 7= Saturday, ODBC Standard)Mysql> Select DAYOFWEEK (' 1998-02-03 ');3WEEKDAY (date)The return date is the day of the week (0= Monday, 1 = Tuesday,...... 6=

DAYOFWEEK (date)The return date is the day of the week (1= Sunday, 2 = Monday,...... 7= Saturday, ODBC Standard)Mysql> Select DAYOFWEEK (' 1998-02-03 ');3WEEKDAY (date)The return date is the day of the week (0= Monday, 1 = Tuesday,...... 6=