Updation mysql date column using Hibernate?

Question

while updating datetime field using new Date() function, it having date part but it time part will be (00.00.00), Insertion it does,t have any problem 2013-08-02 12:57:09 ,but in updation it works like 2013-08-02 00:00:00....

session.createQuery(
"update DeviceDetails u set u.statusUpDate=:statusUpDate where u.id=:dID")
.setDate("statusUpDate", new Date())
.setInteger("dID",dID).executeUpdate();

session.getTransaction().commit()

See this stackoverflow.com/questions/8530545/java-sql-date-time — Elbek
– Elbek, Commented Aug 2, 2013 at 9:26

JB Nizet · Accepted Answer · 2013-08-02 09:24:13Z

3

Use setTimestamp(), and not setDate().

Or don't use a query at all: get the entity using Session.get(), and modify its fields.

answered Aug 2, 2013 at 9:24

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

5 Comments

JB Nizet Over a year ago

Why are you repeating the code you already have in your question in this comment?

Aravind Cheekkallur Over a year ago

I am really interest to know the difference between setDate(),setTimestamp().

JB Nizet Over a year ago

setDate() uses a java.sql.Date (which doesn't have a time portion), whereas setTimestamp() uses a java.sql.Timestamp (which has a time portion). Read the javadoc of those two classes to know the exact difference.

Aravind Cheekkallur Over a year ago

AM using hibernate query to save the date and time...It working perfectly on saving the session object checkAdd.setcheck(newDate()); session.save(checkAdd); session.getTransaction().commit(); Once using update it working with date part not in time part... Actually the problem solved by using setTimestamp() function.Is the mentioned problem occurs because of the java library file

JB Nizet Over a year ago

The problem occurs because you're using setDate(), which means: set the value of the parameter with this date without time value.

Collectives™ on Stack Overflow

Updation mysql date column using Hibernate?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related