Literal of the correct data type required.

You have entered a data type that cannot be converted to a literal of the data type needed for the parameter. This error can occur in the following place:

  • In the value field of Query and View Designer.

SQL objects that contain data have an associated data type that defines the kind of data (character, integer, binary, and so on) the object can contain. When you specify a value, the literal must match the data type defined for the column. For example, you cannot enter an alphabetic string (such as "abc") for a timestamp data type.

For more information on data types, see Data Types (Database Engine).

To correct this error

  • Change the literal to the correct data type.