How to store Java Date to Mysql datetime with JPA

Question

Can any body tell me how can I store Java Date to Mysql datetime...?

When I am trying to do so...only date is stored and time remain 00:00:00 in Mysql date stores like this...

2009-09-22 00:00:00

I want not only date but also time...like

2009-09-22 08:08:11

I am using JPA(Hibernate) with spring mydomain classes uses java.util.Date but i have created tables using handwritten queries...

this is my create statement

CREATE TABLE ContactUs ( id BIGINT AUTO_INCREMENT, userName VARCHAR(30), email VARCHAR(50), subject VARCHAR(100), message VARCHAR(1024), messageType VARCHAR(15), contactUsTime DATETIME, PRIMARY KEY(id) );

These days you should no longer be using java.util.Date at all (in 2010 there probably was no better choice). Better to use the modern classes, like java.time.Instant or java.time.LocalDateTime, depending on the exact requirements for the date-time you need to store. — Anonymous
– Anonymous, Commented Aug 13, 2017 at 6:26
Some of these old answers comeup pretty high on Google rankings. In Java 8+ we can simply use LocalDateTime to save datetime instead of resorting to using @Temporal to save in datetime format — HopeKing
– HopeKing, Commented Aug 31, 2017 at 3:32
preparedStatement.setTimestamp(1, new Timestamp(System.currentTimeMillis())); — Rajat Verma
– Rajat Verma, Commented Dec 12, 2018 at 5:58

RealHowTo · Accepted Answer · 2011-11-19 22:33:38Z

see in the link :

http://www.coderanch.com/t/304851/JDBC/java/Java-date-MySQL-date-conversion

The following code just solved the problem:

java.util.Date dt = new java.util.Date(); java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String currentTime = sdf.format(dt);

This 'currentTime' was inserted into the column whose type was DateTime and it was successful.

but,currentTime is a String object, and in db we take datetime as datatype,i think it is not going to be inserted.right?
yyyy-MM-dd HH:mm:ss is very important. Take note of the capitalization.

Pascal Thivent · Accepted Answer · 2010-03-09 16:43:21Z

97

Annotate your field (or getter) with @Temporal(TemporalType.TIMESTAMP), like this:

public class MyEntity { ... @Temporal(TemporalType.TIMESTAMP) private java.util.Date myDate; ... }

That should do the trick.

answered Mar 9, 2010 at 16:43

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

3 Comments

Perneel Over a year ago

This is the answer indeed!

Ryan Over a year ago

up for this, this is the proper answer.

jon Over a year ago

be aware that if you choose this solution, your date will appear as a timestamp when fetched from db. It won't have the nice formatting 'yyyy-MM-dd....')

Pascal Thivent · Accepted Answer · 2010-03-09 16:38:01Z

38

Are you perhaps using java.sql.Date? While that has millisecond granularity as a Java class (it is a subclass of java.util.Date, bad design decision), it will be interpreted by the JDBC driver as a date without a time component. You have to use java.sql.Timestamp instead.

edited Mar 9, 2010 at 16:38

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

answered Mar 8, 2010 at 11:43

Michael Borgwardt

347k81 gold badges491 silver badges726 bronze badges

2 Comments

Pascal Thivent Over a year ago

I wouldn't use java.sql.Date or java.sql.Timestamp in domain classes but I guess this was written before the edit of the OP.

Doug Moscrop Over a year ago

I would. java.util.Date objects don't compare to java.sql.Timestamp objects with entirely predictable results.

Marcx · Accepted Answer · 2010-03-08 11:43:44Z

Probably because your java date has a different format from mysql format (YYYY-MM-DD HH:MM:SS)

do this

 DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss"); Date date = new Date(); System.out.println(dateFormat.format(date));

You mentioned the correct format in the reference and then used the wrong format in the code.

animuson · Accepted Answer · 2011-11-19 22:24:38Z

you will get 2011-07-18 + time format

long timeNow = Calendar.getInstance().getTimeInMillis(); java.sql.Timestamp ts = new java.sql.Timestamp(timeNow); ... preparedStatement.setTimestamp(TIME_COL_INDEX, ts);

Nikopol · Accepted Answer · 2012-12-25 13:18:45Z

mysql datetime -> GregorianCalendar

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date = format.parse("2012-12-13 14:54:30"); // mysql datetime format GregorianCalendar calendar = new GregorianCalendar(); calendar.setTime(date); System.out.println(calendar.getTime());

GregorianCalendar -> mysql datetime

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String string = format.format(calendar.getTime()); System.out.println(string);

michdraft · Accepted Answer · 2013-06-11 08:48:20Z

java.util.Date date = new Date(); Object param = new java.sql.Timestamp(date.getTime()); preparedStatement.setObject(param);

Yang_2333 · Accepted Answer · 2014-03-12 05:08:31Z

Use the following code to insert the date into MySQL. Instead of changing our date's format to meet MySql's requirement, we can help data base to recognize our date by setting the STR_TO_DATE(?, '%l:%i %p') parameters.

For example, 2014-03-12 can be represented as STR_TO_DATE('2014-03-12', '%Y-%m-%d')

preparedStatement = connect.prepareStatement("INSERT INTO test.msft VALUES (default, STR_TO_DATE( ?, '%m/%d/%Y'), STR_TO_DATE(?, '%l:%i %p'),?,?,?,?,?)");

Yash Agrawal · Accepted Answer · 2017-05-15 18:29:09Z

Its very simple though conditions in this answer are in mysql the column datatype is datetime and you want to send data from java code to mysql:

java.util.Date dt = new java.util.Date();
whatever your code object may be.setDateTime(dt);

important thing is just pick the date and its format is already as per mysql format and send it, no further modifications required.

udith · Accepted Answer · 2022-02-24 03:45:11Z

If using java 8 or higher , try to use LocalDateTime. That was the correct type if you are using DATETIME as mysql data type.

Below is example for conver current time to "2009-09-22 08:08:11" format

LocalDateTime currentTime = LocalDateTime.parse(LocalDateTime.now().toString(), DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));

Sahin Yanlık · Accepted Answer · 2016-12-20 03:57:31Z

Actually you may not use SimpleDateFormat, you can use something like this;

 @JsonSerialize(using=JsonDateSerializer.class) @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd/MM/yyyy HH:mm:ss") private Date blkDate;

This way you can directly get the date with format as specified.

Mohannd · Accepted Answer · 2019-06-14 12:38:34Z

I still prefer the method in one line

new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime())

Miguel Alonso Mosquera Aguilar · Accepted Answer · 2014-11-20 17:54:34Z

it works for me !!

in mysql table

DATETIME

in entity:

private Date startDate;

in process:

objectEntity.setStartDate(new Date());

in preparedStatement:

pstm.setDate(9, new java.sql.Date(objEntity.getStartDate().getTime()));

Collectives™ on Stack Overflow

How to store Java Date to Mysql datetime with JPA

13 Answers 13

2 Comments

3 Comments

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

2 Comments

3 Comments

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related