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

[xx_richard]

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

[Demi1001]

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

[xiyuanna]

参考Calendar类

[lingling295]

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();
}
}

[youandi79]

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

[youandi79]

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