Java数据库保存时分秒时间

        String sql = "UPDATE U_DIST_TASK T SET T.MADE_TIME = to_date(?,'YYYY-MM-DD HH24:MI:SS') WHERE T.TASK_NO = ?";
        DateFormat sdf = new SimpleDateFormat("HH:mm:ss");     
        java.sql.Timestamp time = new java.sql.Timestamp(System.currentTimeMillis());     
        String dateStr = taskPo.getMadeTime()+" "+sdf.format(time);
        Object[] taskdetParam = {dateStr,taskPo.getTaskNo()};
        hibernateDao.updateWithSql(sql.toString(),taskdetParam);

posted on 2018-06-28 11:05  master_lu  阅读(1110)  评论(0编辑  收藏  举报