How to set datetime field in MySql using hql

Question

I am facing an issue in inserting date in YYYY-mm-dd hh:mm:ss format in MySql DB. filed in DB is of type datetime.

I tried it :

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();

in your entity - challange , have you used @Temporal private Date start_time; what is the error that you get? — Sanath
– Sanath, Commented May 8, 2012 at 6:00
try to add a try catch block to capture any exception to find the issue that prevents you from saving the data — Sanath
– Sanath, Commented May 8, 2012 at 6:03
yes with start_time i have @Temporal(javax.persistence.TemporalType.TIMESTAMP) and am not getting nay exception , but in DB i can c only date hh:mm:ss are as 00:00:00 always — Romi
– Romi, Commented May 8, 2012 at 7:31

Jobi Subramunian · Accepted Answer · 2016-01-05 08:33:37Z

5

Try to use the following.

.setTimestamp("startTime", startTime);

answered Jan 5, 2016 at 8:33

Jobi Subramunian

1461 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanath · Accepted Answer · 2012-05-08 08:59:05Z

Here I have specifically tried to format the date object using simpleDateFormat before passing it to the hibernate. 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();

dhh · Accepted Answer · 2015-07-14 05:12:41Z

0

It works for me if use setParameter() instead of setDate() ...

edited Jul 14, 2015 at 5:12

dhh

4,3578 gold badges46 silver badges61 bronze badges

answered Jul 14, 2015 at 4:22

gkumawat

1

Collectives™ on Stack Overflow

How to set datetime field in MySql using hql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related