1.获取前n天的日期
private Date getLastDay(int n) {
Calendar calendar = Calendar.getInstance();
//得到前n天的日期
calendar.add(Calendar.DATE, -n);
Date date = calendar.getTime();
return date;
}
2.日期转周
var weekDay = ["周日", "周一", "周二", "周三", "周四", "周五", "周六"];
var myDate = new Date(Date.parse(datetime));
console.log(Date.parse(datetime));
3.日期转字符串
var date = new Date();
var year = date.getFullYear(); //年
var month =(date.getMonth() + 1).toString(); //月
var day = (date.getDate()).toString(); //日
if (month.length == 1) {
month = "0" + month;
}
if (day.length == 1) {
day = "0" + day;
}
var dateTime = year + "-" + month + "-" + day;
4.oracle查询子节点的所有父节点并合并
select wm_concat(m.ID || '')
from groupname m start with m.id = '207'
connect by prior m.parentId = m.id
结果