如何得到当前时间一个月以前的日期?

Question

如何得到当前时间一个月以前的日期?

Answer 1

select * from custom where  datediff(y,custom_create_time,getdate())>30

Answer 2

import java.util.Calendar;
public class LastMonthTest {
private final static  long oneDayValue=24*60*60*1000;
private Calendar startDate=Calendar.getInstance();
public void getLastMonth() {
     Calendar start=Calendar.getInstance();
     start.setTimeInMillis(startDate.getTimeInMillis()-oneDayValue*30);
     String lastMonth = ""+start.get(Calendar.YEAR)+"-"
     +((start.get(Calendar.MONTH)+1)<10?"0"+(start.get(Calendar.MONTH)+1):""+(start.get(Calendar.MONTH)+1))+"-"
  +(start.get(Calendar.DATE)<10?"0"+start.get(Calendar.DATE):""+start.get(Calendar.DATE));
System.out.println(lastMonth);
}
public static void main(String[] args){
LastMonthTest test = new LastMonthTest();
test.getLastMonth();
}
}

Answer 3

Calendar.getInstance().add(Calendar.MONTH , -1)

Answer 4

Calendar c = Calendar.getInstance();
c.add(Calendar.MONTH , -1);
Date d = c.getTime();