oracl 和db2 常用语法比较： 1、取前N条记录 Oracle：Select * from TableName where rownum <= N; DB2：Select * from TableName fetch first N rows only; 2、取得系统日期 Oracle：Select sysdate from dual; DB2：Select current timestamp from sysibm.sysdummy1; 3、空值转换 Oracle：Select
Calendar cal = Calendar.getInstance(); cal.setTime(new Date()); int year = cal.get(Calendar.YEAR);//获取年份 int month=cal.get(Calendar.MONTH);//获取月份 int day=cal.get(Calendar.DATE);//获取日 int hour=cal.get(Calendar.HOUR);//小时 System.out.println(year); Sim
