如何在 JAVA 中将纪元转换为 mySQL 时间戳
问题描述:
如何在mySQLtimestamp
中获取mySQL时间戳格式?
How to get mySQL timestamp format in mySQLtimestamp
?
long epochNow = System.currentTimeMillis()/1000;
long epochWeek = 604800;
long date7daysAgo = epochNo2013 w - epochWeek;
String mySQLtimestamp = /* 2013-09-23:50:00 */
答
为什么不一直使用普通的Date
?
Why not use a normal Date
all along?
Calendar cal = Calendar.getInstance();
cal.add(Calendar.DAY_OF_MONTH, -7);
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String output = formatter.format(cal.getTime());