Convert java.sql.Date to java.sql.Timestamp

Question

Is there a way to convert java.sql.Date to java.sql.Timestamp?

I have the following code:

java.sql.Date = new Date();
java.sql.Timestamp timestamp = new java.sql.Timestamp(date);

But the Timestamp constructor doesn't seem to support that variable type.

Should not it be `java.sql.Date date = new Date();`? Is it a typo or are you missing variable name? — zkanoca, Jan 12 '16 at 14:58
u can fetch time in milliseconds and then get it converted in my opinion — Srinath Ganesh, Jan 12 '16 at 15:00
http://stackoverflow.com/questions/22856931/converting-java-date-to-sql-timestamp — Reimeus, Jan 12 '16 at 15:05

score 18 · Accepted Answer · answered Jan 12 '16 at 14:59

18

You can get the constructor that takes milliseconds as argument, like:

java.sql.Date date = new Date();
java.sql.Timestamp timestamp = new java.sql.Timestamp(date.getTime());

answered Jan 12 '16 at 14:59

dan

1 Answers1