Announcement

Collapse
No announcement yet.

Problem with UK-format dates

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Problem with UK-format dates

    Ultralog seems to be using US-format dates for UK-configured SQL Server 2005, despite Ultralog configuration (greyed-out) saying that the format is dd/MM/yyyy HH:mm:ss.

    Log reads (example error -- note date format in last line):
    ---------
    InsertDeviceStatusIntoDB() Reports Error: [System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExcep tion exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(Tds ParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(Strin g methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HSPI_ULTRALOG.Database.InsertDeviceStatusIntoDB(DateTime ts, String hc, String dc, Int32 status, Int32 data1, Int32 data2)], Failed on SQL: INSERT INTO tblDeviceStatusLog (ts, hc, dc, status, data1, data2) VALUES ('5/13/2013 10:03:25 PM','G','G9',3,0,0).

    Please can you help? Many thanks.

    #2
    Bump

    Anyone able to help, please?

    Comment


      #3
      Bump

      Really disappointed that no-one has an answer for this. Please help!!!

      Comment

      Working...
      X