Literal of the correct data type required.
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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).

  1. Change the literal to the correct data type.

© 2016 Microsoft