How to convert sql date to java

Question

SO i have a table in my database, date declared as date. and now i'm coding in java and i need the DATE to be inputted by the user and store it in my database. how does it work? i mean to convert date in to what? thank you!!

for now this is my code

        java.util.Date utilDate = new java.util.Date();
        java.sql.Date sqldate = new java.sql.Date(utilDate.getTime());
        System.out.print("更新日: ");
        String 更新日 = input.nextLine();

What version of SQL are you using (e.g. MySQL, SQL Server, etc.) ? — Tim Biegeleisen, Oct 25 '16 at 05:03
Search Stack Overflow before posting. This has been handled many many times already. — Basil Bourque, Oct 25 '16 at 16:01

score 0 · Answer 1 · answered Oct 25 '16 at 05:08

If you are using SQL SERVER, the following code will convert your date to SQL Server format.

java.util.Date utilDate = new java.util.Date(); //date that needs conversion
java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime()); //converts to SQL date format

How to convert sql date to java

1 Answers1