统计的一些常用,关于时间日期报错和处理方式的解决办法:
1. 错误:Cannot format given Object as a Date
原因:传值是对象不是日期类型,将begintime 转化一下
将String begin=sdf.format(begintime)
修改为:String begin=sdf.format(DateFormat.getDateInstance().parse(begintime))即可。SimpleDateFormat 的format方法是:public final java.lang.String format(java.util,Date org0); format方法应该传一个Date类型的参数,而不是String 或者是其它的。
2.获取最小时间:
private static String showResultMinTime(List<String> date) {
Map<String, Integer> dateMap = new TreeMap<String, Integer>();
int i, arrayLen;
arrayLen = date.size();
for(i = 0; i < arrayLen; i++){
String dateKey = date.get(i);
if(dateMap.containsKey(dateKey)){
int value = dateMap.get(dateKey) + 1;
dateMap.put(dateKey, value);
}else{
dateMap.put(dateKey, 1);
}
}
Set<String> keySet = dateMap.keySet();
String []sorttedArray = new String[keySet.size()];
Iterator<String> iter = keySet.iterator();
int index = 0;
while (iter.hasNext()) {
String key = iter.next();
sorttedArray[index++] = key;
}
return sorttedArray[0];
}
3.对一个list集合的时间进行排序:
List<String> date = new ArrayList<>();
date.addAll(set);
ComparatorDate c = new ComparatorDate();
Collections.sort(date, c);
//对时间进行排序
class ComparatorDate implements Comparator {
@Override
public int compare(Object obj1, Object obj2) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date begin = null;
Date end = null;
try {
begin = sdf.parse(String.valueOf(obj1));
end = sdf.parse(String.valueOf(obj2));
} catch (ParseException e) {
e.printStackTrace();
}
if (begin.after(end)) {
return 1;
} else {
return -1;
}
}
}
4.获取最近多少(day)天的日期:
private List<String> getDateList(int day) {
List<String> list = new ArrayList<>();
Date now = new Date();
for (int i = 1; i <= day; i++) {
Calendar c = Calendar.getInstance();
c.setTime(now);
c.add(Calendar.DAY_OF_MONTH, -i);
String timeStr = dayFormat(c.getTime());
list.add(timeStr);
}
Collections.reverse(list);
return list;
}
public static String dayFormat(Date date) {
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
String dateString = formatter.format(date);
return dateString;
}
5.获取最近12个月
private static List getLast12Months() {
List last12Months = new ArrayList();
LocalDate today = LocalDate.now();
for(long i = 0L;i <= 11L; i++){
LocalDate localDate = today.minusMonths(i);
String ss = localDate.toString().substring(0,7);
last12Months.add(ss);
}
return last12Months;
}
6.计算两个日期间隔的年月日等:
select TIMESTAMPDIFF(DAY, time1, time2)
(1. FRAC_SECOND。表示间隔是毫秒
2. SECOND。秒
3. MINUTE。分钟
4. HOUR。小时
5. DAY。天
6. WEEK。星期
7. MONTH。月
8. QUARTER。季度
9. YEAR。年)