###Java:
/** 日期转字符串,返回指定格式yyyy-MM-dd */
public static String getDateToString(Date date, String format) {
if (date == null)
return null;
SimpleDateFormat fmt = new SimpleDateFormat(format);
String d = null;
try {
d = fmt.format(date);
} catch (Exception e) {
e.printStackTrace();
d = null;
}
return d;
}
/** 字符串转日期,返回指定格式yyyy-MM-dd */
public static Date getStringToDate(String date, String format) {
if (date == null)
return null;
SimpleDateFormat fmt = new SimpleDateFormat(format);
Date d = null;
try {
d = fmt.parse(date);
} catch (Exception e) {
e.printStackTrace();
d = null;
}
return d;
}
/** 时间戳转时间 yyyy-MM-dd */
public static Date timestampToDate(Long dateTime) {
try {
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
if (dateTime != null) {
String dateString = format.format(dateTime);
return format.parse(dateString);
}
} catch (ParseException e) {
e.printStackTrace();
}
return null;
}
Jquery:
Date.prototype.format = function(format) {
var date = {
"M+": this.getMonth() + 1,
"d+": this.getDate(),
"h+": this.getHours(),
"m+": this.getMinutes(),
"s+": this.getSeconds(),
"q+": Math.floor((this.getMonth() + 3) / 3),
"S+": this.getMilliseconds()
};
if (/(y+)/i.test(format)) {
format = format.replace(RegExp.$1, (this.getFullYear() + '').substr(4 - RegExp.$1.length));
}
for (var k in date) {
if (new RegExp("(" + k + ")").test(format)) {
format = format.replace(RegExp.$1, RegExp.$1.length == 1
? date[k] : ("00" + date[k]).substr(("" + date[k]).length));
}
}
return format;
}
使用:
//时间戳转Date 格式化
var newDate = new Date();
var stime = data.stime;
newDate.setTime(stime * 1000);
$("#pf-company-youhui-valid-stime").val(newDate.format('yyyy-MM-dd'));
var ltime = data.ltime;
newDate.setTime(ltime * 1000);
$("#pf-company-youhui-valid-ltime").val(newDate.format('yyyy-MM-dd'));
时间正则表达式验证:
// 判断日期类型是否为YYYY-MM-DD格式的类型
var str = $("#pf-company-youhui-valid-ltime").val();
if (str.length != 0) {
var reg = /^(\d{1,4})(-|\/)(\d{1,2})\2(\d{1,2})$/;
var r = str.match(reg);
if (r == null) {
$("#pf-company-youhui-valid-ltime").val(null);
}
}
Mysql
mysql中,sql 语句的时间戳转换
SELECT FROM_UNIXTIME( 1249488000, '%Y%m%d' )
UNIX_TIMESTAMP()将日期时间转换为时间戳
UPDATE jh_article SET createTime = from_unixtime(dateline) where dateline>0