https://answers.axonivy.com/tags/database_conversion/?type=rss&user=dbalassequestions tagged <span class="tag">database_conversion</span>enMon, 23 Mar 2015 17:45:22 -0400https://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>dbalasseMon, 23 Mar 2015 17:45:22 -0400https://answers.axonivy.com/questions/1238/storing-datetime-in-databasedatabase_conversion