oracle查看当前日期是第几个星期的方式_数据库恢
日期:2014-06-07 / 人气: / 来源:网络
相关操作代码如下:
int year=2011;
int week=1;
Calendar calFirstDayOfTheYear = new GregorianCalendar(year,
Calendar.JANUARY, 1);
calFirstDayOfTheYear.add(Calendar.DATE, 7 * (week-1));
int dayOfWeek = calFirstDayOfTheYear.get(Calendar.DAY_OF_WEEK);
Calendar calFirstDayInWeek = (Calendar)calFirstDayOfTheYear.clone();
calFirstDayInWeek.add(Calendar.DATE,
calFirstDayOfTheYear.getActualMinimum(Calendar.DAY_OF_WEEK) - dayOfWeek);
Date firstDayInWeek = calFirstDayInWeek.getTime();
System.out.println(year "年第" week "个礼拜的第一天是" ReportDateUtil.getFromatDay().format(firstDayInWeek));
Calendar calLastDayInWeek = (Calendar)calFirstDayOfTheYear.clone();
calLastDayInWeek.add(Calendar.DATE,
calFirstDayOfTheYear.getActualMaximum(Calendar.DAY_OF_WEEK) - dayOfWeek);
Date lastDayInWeek = calLastDayInWeek.getTime();
System.out.println(year "年第" week "个礼拜的最后一天是" ReportDateUtil.getFromatDay().format(lastDayInWeek));
oracle存储过程中return和exit区别概述及测试
至于return和exit在oracle存储过程中的应用,有些新手兄弟姐妹们还是比较容易混淆的,该文档将针对这两个关键字进行详细对比下,感兴趣的你可以参考下,希望可以帮助到你
存储过程,return,exit,Oracle存储过程
作者:管理员
推荐内容 Recommended
- 江苏飞浩信息科技期待您的加入07-20
- 江苏飞浩科技欢迎您07-19
相关内容 Related
- 江苏飞浩信息科技期待您的加入07-20
- 江苏飞浩科技欢迎您07-19