how to convert the SQL date type to Java param

Question

I have a field in sql table of type date with value 1944-01-02. Now I am writing a java function which will pull this data from the database and use it as a java method param. How should I handle it?

method looks like this:

void search(Date date);

I want to put 1944-01-02 in to the method param, but java complier complain does not matter if I import java.util.date or java.sql.date.

`but java complier complain` can you please be more specific? — tnw, Jul 21 '15 at 19:31
You get a ResultSet and then the date from it? In this case it will be a java.sql.Date (which strips hours, minutes, seconds and mili seconds) — maraca, Jul 21 '15 at 19:40

score 0 · Accepted Answer · edited May 23 '17 at 11:44

0

You have to convert your sql date to java date:

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

Get more info about this at this Link

edited May 23 '17 at 11:44

Community

1
1

answered Jul 21 '15 at 19:38

Nero

422
8
22

score 0 · Answer 2 · answered Jul 21 '15 at 19:47

0

You might be looking for this:

search(Date.valueOf("1944-01-02"));

Format: yyyy-[m]m-[d]d

answered Jul 21 '15 at 19:47

maraca

8,468
3
23
45

how to convert the SQL date type to Java param

2 Answers2