Geek asks and answers

How to set datetime field in MySql using hql

I had a problem entering a date in the format YYYY-mm-dd hh: mm: ss in the MySql database. submitted to the database is of type datetime.

I tried:

Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
calendar.set(Calendar.MINUTE, startMinute);
calendar.set(Calendar.SECOND,01);
Date startTime = calendar.getTime();

String hqlUpdate = "update challenge set start_time = :startTime where challenge_id =  :id";
sessionFactory.getCurrentSession().createSQLQuery(hqlUpdate)
                                 .setDate("startTime", startTime)
                                 .setInteger("id", id).executeUpdate();
+3
source share
3 answers

Try using the following.

.setTimestamp("startTime", startTime);
+2
source

Here, I specifically tried to format the date object with simpleDateFormat before putting it to sleep. check if this works.

DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
calendar.set(Calendar.MINUTE, startMinute);
calendar.set(Calendar.SECOND,01);
Date startTime = dateFormat.parse(dateFormat.format(calendar.getTime();));

String hqlUpdate = "update challenge set start_time = :startTime where challenge_id =  :id";
sessionFactory.getCurrentSession().createSQLQuery(hqlUpdate)
                             .setDate("startTime", startTime)
                             .setInteger("id", id).executeUpdate();
0
source

It works for me if used setParameter()instead setDate()...

0
source

More articles:


All Articles