https://answers.axonivy.com/questions/1238/storing-datetime-in-database<p>Hello,</p> <p>we use database (sqlserver) to store values. One of those field is an ivy DateTime. When we try to store it in the database we have this error :</p> <p>com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)</p> <p>The ivy field is a ch.ivyteam.ivy.scripting.objects.DateTime and it must be stored in a smalldatetime filed from sqlserver (10.50.4000.0).</p> <p>What are we doing wrong ?</p>enWed, 25 Mar 2015 16:34:53 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database/1239<p>Hi there</p> <p>Possibilities I could think of:</p> <ul> <li>Date is out of range for MS SQL. auto initialized DateTimes are '0001-01-01 00:00:00', but MS SQL accepts only a date between January 1, 1753 and December 31, 9999</li> <li>The language of the MS SQL user isn't english -&gt; DateTime Format is different <a href="https://msdn.microsoft.com/de-ch/library/ms174398%28v=sql.105%29.aspx">SET LANGUAGE</a></li> </ul>Peter StöckliWed, 25 Mar 2015 16:34:53 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database/1239