Êý¾Ý¿â×Ö¶Î dateline int (·¢²¼Ê±¼ä£© ÖµÊÇ 1268053581
Java code:
for(int i=0;i<array_polls.size();i++)
{
Polls polls=(Polls)array_polls.get(i);
Threads threads = (Threads)pollotionDaoImpl.findPostsByid(polls.getTid());
long starttime=threads.getDateline()/1000;
long endtime= System.currentTimeMillis();
String runTime=Common.number_format((endtime-starttime)/1000f, "0.000000");
System.out.println("starttiem: "+starttime);
System.out.println("endtime: "+endtime);
System.out.println("runTime: "+runTime);
System.out.println("Êý¾Ý¿âʱ¼ä"+Math.abs(threads.getDateline()/1000));
// System.out.println( Common.toDigit(String.valueOf(threads.getDateline()))*3600);
arry_threads.add(threads);
}
Êä³öÓï¾ä
starttiem: 1268053
endtime: 1268104946062
runTime: 1268103680.000000
Êý¾Ý¿âʱ¼ä£º 14676
ÒªÔõôÑùת»»Ñ½£¿£¿
Ôõô´ÓºÁÃëÊýת»ØÀ´Ñ½£¿£¿£¿
Date start = new Date(starttime*1000)
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......