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存储过程

作者:管理员




现在致电4006-2991-90 OR 查看更多联系方式 →

Go To Top 回顶部