Converting java.sql.Date to java.util.Date

Question

What's the simplest way to convert a java.sql.Date object to a java.util.Date while retaining the timestamp?

I tried:

java.util.Date newDate = new Date(result.getDate("VALUEDATE").getTime());

with no luck. It's still only storing the date portion into the variable.

This inheritance is a weird design legacy – seand May 20 '11 at 00:45 — seand, May 20 '11 at 00:45

x4u · Accepted Answer · 2011-05-20T00:53:38.853

72

The class java.sql.Date is designed to carry only a date without time, so the conversion result you see is correct for this type. You need to use a java.sql.Timestamp to get a full date with time.

java.util.Date newDate = result.getTimestamp("VALUEDATE");

edited May 20 '11 at 00:53

answered May 20 '11 at 00:43

x4u

13,877
6
48
58

3

I'll try this then: new Date(result.getTimestamp("VALUEDATE").getTime()); – mservidio May 20 '11 at 00:48
1

this should work, but since `java.sql.Timestamp` also derives from `java.util.Date` you could as well just use the Timestamp instance. – x4u May 20 '11 at 00:53

score 20 · Answer 2 · edited May 28 '18 at 11:47

20

If you really want the runtime type to be util.Date then just do this:

java.util.Date utilDate = new java.util.Date(sqlDate.getTime());

Brian.

edited May 28 '18 at 11:47

Farvardin

5,336
5
33
54

answered Mar 27 '14 at 21:49

brianbruff

2,092
2
14
14

@PlexQ : It should if your sqlDate is null, but perhaps I'm missing something obvious as you appear to have used a lot of exclamation marks. – brianbruff Jun 03 '21 at 14:22

score 9 · Answer 3 · edited Feb 22 '13 at 19:18

9

Since java.sql.Date extends java.util.Date, you should be able to do

java.util.Date newDate = result.getDate("VALUEDATE");

edited Feb 22 '13 at 19:18

doelleri

19,232
5
61
65

answered May 20 '11 at 00:44

Bala R

107,317
23
199
210

1

Yes, but in runtime, `newDate` will still be an instance of `java.sql.Date` – Joey Baruch Oct 05 '16 at 11:56
it's true what @joeybaruch says, and there if you try the .toInstant() method you'll get an UnsopportedMethodException, so it's not recommended – Leonardo G. May 25 '18 at 22:04

score 7 · Answer 4 · edited Nov 22 '16 at 09:58

7

This function will return a converted java date from SQL date object.

public static java.util.Date convertFromSQLDateToJAVADate(
            java.sql.Date sqlDate) {
        java.util.Date javaDate = null;
        if (sqlDate != null) {
            javaDate = new Date(sqlDate.getTime());
        }
        return javaDate;
    }

edited Nov 22 '16 at 09:58

ejvk

5
2

answered Jan 05 '15 at 10:27

Tanmay kumar shaw

199
4
9

Stephen C · Answer 5 · 2011-05-20T00:56:09.367

4

From reading the source code, if a java.sql.Date does actually have time information, calling getTime() will return a value that includes the time information.

If that is not working, then the information is not in the java.sql.Date object. I expect that the JDBC drivers or the database is (in effect) zeroing the time component ... or the information wasn't there in the first place.

I think you should be using java.sql.Timestamp and the corresponding resultset methods, and the corresponding SQL type.

edited May 20 '11 at 00:56

answered May 20 '11 at 00:47

Stephen C

698,415
94
811
1,216

I'm querying against Oracle 10g. Using ojdbc14.jar – mservidio May 20 '11 at 00:53

score -2 · Answer 6 · answered May 12 '15 at 09:35

-2

In the recent implementation, java.sql.Data is an subclass of java.util.Date, so no converting needed. see here: https://docs.oracle.com/javase/1.5.0/docs/api/java/sql/Date.html

answered May 12 '15 at 09:35

Stanley Shi

679
1
5
9

Converting java.sql.Date to java.util.Date

6 Answers6

Linked