[b]打印昨天的现在时间
[size=large]Oracle[/b][/size]
select to_char(sysdate-1,'yyyy-MM-dd HH24:mi:ss') from dual
[b][size=large]Java[/size][/b]
Calendar calendar=Calendar.getInstance();
calendar.setTime(new Date());
String year=String.valueOf(calendar.get(Calendar.YEAR)),
month=String.valueOf(calendar.get(Calendar.MONTH)+1),
day=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)),
week=String.valueOf(calendar.get(Calendar.DAY_OF_WEEK)-1);
int hour=calendar.get(Calendar.HOUR_OF_DAY),
minute=calendar.get(Calendar.MINUTE),
second=calendar.get(Calendar.SECOND);
System.out.println("现在的时间是:");
System.out.println(""+year+"年"+month+"月"+day+"日 "+ "星期"+week);
System.out.println(""+hour+"时"+minute+"分"+second+"秒");
[size=large]Oracle[/b][/size]
select to_char(sysdate-1,'yyyy-MM-dd HH24:mi:ss') from dual
[b][size=large]Java[/size][/b]
Calendar calendar=Calendar.getInstance();
calendar.setTime(new Date());
String year=String.valueOf(calendar.get(Calendar.YEAR)),
month=String.valueOf(calendar.get(Calendar.MONTH)+1),
day=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)),
week=String.valueOf(calendar.get(Calendar.DAY_OF_WEEK)-1);
int hour=calendar.get(Calendar.HOUR_OF_DAY),
minute=calendar.get(Calendar.MINUTE),
second=calendar.get(Calendar.SECOND);
System.out.println("现在的时间是:");
System.out.println(""+year+"年"+month+"月"+day+"日 "+ "星期"+week);
System.out.println(""+hour+"时"+minute+"分"+second+"秒");