input character string does not follow style 112, either change the input ch

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  March 3, 2020 at 3:10 pm

  #3730586

  Hi,

  I'm getting an obscure issue when

  when I run this SQL statement

  SELECT  TOP 1 S_Date from tbl_name order by RowID

  I get  this error message :

  Msg 9807, Level 16, State 0, Line 1

  The input character string does not follow style 112, either change the input character string or use a different style.

  but it is OK when I leave out the "order by RowID".

  Both SQL Statements will return the same first row and the value of S_Date is NULL and is of type date

  Any help welcome!!!

  Thanks,

  Eamon

   

   

• Phil Parkin

  SSC Guru

  Points: 246987

  More actions

  March 3, 2020 at 3:11 pm

  #3730588

  What is the DataType of RowId?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• frederico_fonseca

  SSCoach

  Points: 16167

  More actions

  March 3, 2020 at 6:21 pm

  #3730669

  are you sure that tbl_name  is really a table and not a view?

  that SQL so simple would give that error if it was from a view with invalid data on the underlying table(s)