SQL Time (DateTime) calculation

SELECT
*
From
Sc_sowu_orderreturn
WHERE
STATUS = ' 0 '
and Submit_time < Date_add (now (), INTERVAL-4 Day)

The above SQL query data with a status of 0 4 days ago

In Java. Text. SimpleDateFormat and Java. util. Date to implement

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 ()-2 * 24 * 60 * 60 * 1000)));
System.out.println ("Date after three days:" + df.format (new Date (D.gettime () + 3 * 24 * 60 * 60 * 1000)));

Abstract: http://blog.csdn.net/liwenfeng1022/article/details/6534176/

SQL Time (DateTime) calculation