date minus

Date D=new date ();SimpleDateFormat df=new SimpleDateFormat ("Yyyy-mm-dd");System.out.println ("Today's Date:" +df.format (d));System.out.println ("Two days ago Date:" + Df.format (new Date (D.gettime ()-(LONG) 2 * 24 * 60 * 60 *

MySQL Date TypeMySQL Date Type: Date format, occupied storage space, date range comparison.Date type storage space Date format date range------------  ---------   --------------------- -----------------------------------------DateTime 8 bytes

//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

//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

Add and subtract based on the date passed in, integer is addition, negative number is subtraction, but day.Num can be passed in: 1,2,3,-1,-2,-3, and so on, the default is to add a day; date can be passed in: 2017-01-01 format, the default is the day

In the actual processing, there is a more alternative date plus and minus processing, that is, in the specified date, plus (or minus) multiple date parts, such as March 11, 2005, plus 1 years 3 months 11 days 2 hours. The power of the DateAdd

Today DateTime.Now.Date.ToShortDateString (); Yesterday, it was today's date minus one. DateTime.Now.AddDays (-1). ToShortDateString (); Tomorrow, in the same vein, add a DateTime.Now.AddDays (1). ToShortDateString (); This week,

//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

http://www.cnblogs.com/dekevin/p/4551843.html//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).

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char