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>enMon, 30 Mar 2015 16:43:19 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1242<p>Have you tried using the jTDS driver for MSSQL? (You can switch the driver in use in the Databases configuration UI)</p>Peter StöckliMon, 30 Mar 2015 16:43:19 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1242https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1241<p>Hi what is the language of the MSSQL DB User in use?</p>Peter StöckliThu, 26 Mar 2015 10:24:07 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1241https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1240<p>Hi,</p> <p>i've solved this by changing the DateTime to a java.sql.Date. Then I format this date in a string with the right format ("yyyy-MM-dd hh:mm:ss").</p> <p>It worked well on my dev environment but on the client's TST env, the format was different, days and month were inverted ("yyyy-dd-MM hh:mm:ss")</p> <p>In the futur, what would be an "ivy" standard way to store Date ?</p> <p>Thanks for your answer.</p>dbalasseWed, 25 Mar 2015 16:45:06 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-database#1240https://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