getting value from jDateChooser and saving to MS sql DB

Question

I have two jDateChooser on my dialog , I want to save to MS-SQL DB having issue with that data types. Any idea how to fix this issue ! I can only do this when i convert data type to nvarchar in DB and convert the value to string which returns from jDateChooser.

enter image description here

// I can save in this way but I it doesn't use jDateChooser;

   java.util.Date utilDate = new java.util.Date();
   java.sql.Date sqldate = new java.sql.Date(utilDate.getTime());

// I cant save the date with jDateChooser

    java.sql.Date sqldate = new java.sql.Date(jDateChooser3.getDate());

// Only Way I found

  SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");

  String sd = dateFormat.format(jDateChooser3.getDate());

  obj.setStartDate(sd);

//

Where is this `JDateChooser` class coming from? Which library and package? — icza, May 09 '14 at 12:25
Please post MCVE (Minimal Complete and Verifiable Example). By the mean time please check the return type of JdateChooser.getDate() if it is java.util.Date then try java.sql.Date sqldate = new java.sql.Date(jDateChooser3.getDate()getTime()); — A Stranger, May 09 '14 at 12:34

score 5 · Accepted Answer · answered May 09 '14 at 12:34

5

Judging from the code you posted it looks like jDateChooser3.getDate() returns a java.util.Date instance while the java.sql.Date(millis) constructor expects the date/time as a long milliseconds value.

Use this code and it will work:

java.sql.Date sqldate = new java.sql.Date(jDateChooser3.getDate().getTime());

Since it comes from a date chooser component, invalid input most likely results in null returned date, so you might want to also check on that:

java.util.Date d = jDateChooser3.getDate();
if (d == null) {
    System.out.println("No date specified!");
} else {
    java.sql.Date sqldate = new java.sql.Date(d.getTime());
    // Do something with sqldate
}

answered May 09 '14 at 12:34

icza

389,944
63
907
827

how about calculating days between these two dates – user3498019 May 09 '14 at 12:36
Days between two dates: http://stackoverflow.com/questions/7103064/java-calculate-the-number-of-days-between-two-dates – icza May 09 '14 at 12:37
hey man it saves the database like this it doesn't show the time 2014-05-12 00:00:00.000 – user3498019 May 13 '14 at 14:32
And what exactly is the problem with having no time? Doesn't the date come from a date chooser which doesn't specify the time? – icza May 14 '14 at 04:46
I cant save the time to database ! that is the problem how to combine all together – user3498019 May 14 '14 at 14:42
You have to use the SQL type `java.sql.Timestamp` instead of `java.sql.Date` if you also want to save time too. – icza May 14 '14 at 14:58
yeah it is working now but one more problem the format of the date 2014-05-01 16:46:45.123 i want in this way dd/MM/yyyy – user3498019 May 15 '14 at 13:49

score 0 · Answer 2 · answered May 20 '15 at 21:21

0

Right click on jDateChooser. Go to the Properties and dateFormatString. Set this format: dd-MM-yyyy.

answered May 20 '15 at 21:21

JustALady

1
1

score 0 · Answer 3 · answered Jul 05 '21 at 16:28

0

      Date keyword = jDateChooserattendance.getDate();
      java.sql.Date sqldate = new java.sql.Date(keyword.getTime());

answered Jul 05 '21 at 16:28

Jalana Kannangara

11
2

getting value from jDateChooser and saving to MS sql DB

3 Answers3

Linked