当年SELECT trunc(sysdate, 'yyyy') from dual
当月SELECT trunc(sysdate, 'mm') from dual
当日SELECT sysdate from dual
问题:如何取系统当前日期所对应的去年的年、月、日日期?
谢谢大家!
当月SELECT trunc(sysdate, 'mm') from dual
当日SELECT sysdate from dual
问题:如何取系统当前日期所对应的去年的年、月、日日期?
谢谢大家!
SimpleDateFormat fmtrq=new SimpleDateFormat("yyyy-MM-dd",Locale.US);
DateFormat df=DateFormat.getDateInstance();
now.add(GregorianCalendar.YEAR,-1);
看看这个行吗?
SQL> SELECT SYSDATE,
2 TRUNC(ADD_MONTHS(SYSDATE,-12),'YYYY') LAST_YEAR,
3 TRUNC(ADD_MONTHS(SYSDATE,-12),'MM') LAST_MM,
4 ADD_MONTHS(SYSDATE,-12) LAST_YEAR_DATE
5 FROM DUAL;SYSDATE LAST_YEAR LAST_MM LAST_YEAR_DATE
----------- ----------- ----------- --------------
2008-12-3 6 2007-1-1 2007-12-1 2007-12-3 6:24