Databases
StackOverflow2013
Postsdbo
POhow to insert null value into datetime column in sql with java
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to insert null value into datetime column in sql with java
    primarykey
    data
    text
    <p>Does anyone know how to set a null value into a datetime column in a database in sql? I tried setting the String as null: <code>String date = null;</code> but i would get this error: </p> <p><code>java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string</code>.</p> <p>Also I tried setting my string to no value by simply declaring it (String date;). however this would just end up setting the date as January 1, 1900. </p> <p>I used 3 dropdown boxes for the user of the program to choose the month, day, and year each. </p> <pre><code>DateNew newdateprocessed; int b, c; String d; //First I took the values from each drop down box. b = Date_Processed_Month_Mod.getSelectedIndex(); c = Date_Processed_Day_Mod.getSelectedIndex(); d = Date_Processed_Year_Mod.getSelectedItem().toString(); newdateprocessed = new DateNew(b, c, d); //Then I used these values in a separate function to put them all together as just one string public class DateNew extends Object { String newdate; String monthword, newdateword; int check=0; public DateNew (int month, int day, String year) { //newdate = ""+ month + "/" + day + "/" + year; if (month == 0 | day == 0 | year.equals("Year")) { newdate=null; check = 1; } else { switch (month) { case 1: monthword="January"; break; case 2: monthword="February"; break; case 3: monthword="March"; break; case 4: monthword="April"; break; case 5: monthword="May"; break; case 6: monthword="June"; break; case 7: monthword="July"; break; case 8: monthword="August"; break; case 9: monthword="September"; break; case 10: monthword="October"; break; case 11: monthword="November"; break; case 12: monthword="December"; break; } newdateword= monthword + " " + day + ", " + year; newdate = ""+ month + "/" + day + "/" + year; } check=month; } public String newdate() { return newdate; } public int newdatecheck(){ return check; } public String newdateword(){ return newdateword; } </code></pre> <p>Lastly, I would give newdateprocessed.newdate() to the column in my database. It would work fine if the user would choose a date, but if they did not choose a date that I would get an error, which is why I am trying to find a way to be able to put a null value. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USa_horse_with_no_name
    1. USmeebee
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POhow to insert null value into datetime column in sql with java
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POhow to insert null value into datetime column in sql with java
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POhow to insert null value into datetime column in sql with java
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you checked whether there is a not null constraint on the date column?
      singulars
      1. POhow to insert null value into datetime column in sql with java
      1. USJosef K
    2. COyes, i set the column to allow null values
      singulars
      1. POhow to insert null value into datetime column in sql with java
      1. USmeebee
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload