SELECT WEEK( "2022-01-01", 0 ) AS model0, WEEK ( "2022-01-01", 1 ) AS model1, WEEK ( "2022-01-01", 2 ) AS model2, WEEK ( "2022-01-01", 3 ) AS model3, WEEK ( "2022-01-01", 4 ) AS model4, WEEK ( "2022-01-01", 5 ) AS model5, WEEK ( "2022-01-01", 6 ) AS model6, WEEK ( "2022-01-01", 7 ) AS model7 UNIOn SELECT WEEK( "2022-01-02", 0 ) AS model0, WEEK ( "2022-01-02", 1 ) AS model1, WEEK ( "2022-01-02", 2 ) AS model2, WEEK ( "2022-01-02", 3 ) AS model3, WEEK ( "2022-01-02", 4 ) AS model4, WEEK ( "2022-01-02", 5 ) AS model5, WEEK ( "2022-01-02", 6 ) AS model6, WEEK ( "2022-01-02", 7 ) AS model72022-01-02 为星期日,执行sql的到如下不同效果 不同的原因主要有以下几点
- 第一周如果不超过3天是算到去年的最后一周还是今年的第一周
- 星期一还是星期天作为一周的第一天
public static void main(String[] args) {
Calendar instance = Calendar.getInstance();
instance.set(2022, 0, 2);
System.out.println(DateUtil.format((instance.getTime()), DateUtil.PATTERN_DATETIME+" E"));
System.out.println("当年第几月:" + instance.get(Calendar.MONTH));
System.out.println("当月第几天:" + instance.get(Calendar.DAY_OF_MONTH));
System.out.println("当周第几天:" + instance.get(Calendar.DAY_OF_WEEK));
System.out.println("当年第几天:" + instance.get(Calendar.DAY_OF_YEAR));
System.out.println("当月第几周:" + instance.get(Calendar.WEEK_OF_MONTH));
System.out.println("当年第几周:" + instance.get(Calendar.WEEK_OF_YEAR));
System.out.println("当月第几个七天:" + instance.get(Calendar.DAY_OF_WEEK_IN_MONTH));
}
得到如下结果
2022-01-02 23:43:19 周日 当年第几月:0 当月第几天:2 当周第几天:1 当年第几天:2 当月第几周:2 当年第几周:2 当月第几个七天:1 2022-01-03 23:43:53 周一 当年第几月:0 当月第几天:3 当周第几天:2 当年第几天:3 当月第几周:2 当年第几周:2 当月第几个七天:1Calendar的周从星期天开始,第一周不足三天当年的第一周算,对应mysql的week的模式0,不同点是mysql的周从0开始算,Calendar则从1开始算 Calendar的月从0开始算



