我有一个SQL数据库,其中有一个year和week字段,我需要获取月份数据。当我尝试检索它时,它会给我下一个月,即当周在月底时。例如,从2019.01.28-2019.02.01周,我得到月份数字2。
有什么问题吗?
(附加信息:我也尝试过其他day_of_week )
代码如下:
rs = stmt.executeQuery("SELECT * FROM " + sqlDatabase.beosztas() + " WHERE id = \'" + id + "\'");`
ResultSetMetaData md = rs.getMetaData();
while (rs.next()) {
year = rs.getInt(2);
week = rs.getInt(3);
cal.set(Calendar.YEAR, year);
cal.set(Calendar.WEEK_OF_YEAR, week);
cal.set(Calendar.DAY_OF_WEEK, 1);
if (count == 0) {
month = cal.get(Calendar.MONTH) + 1;
}
count++;
}
https://stackoverflow.com/questions/50728357
复制相似问题