CONVERT

CONVERT(expr1,DataType)
Returns the value of expr1 converted into DataType , which is one of the following:
  • SQL_BIGINT
  • SQL_BINARY
  • SQL_BIT
  • SQL_CHAR
  • SQL_DATE
  • SQL_DECIMAL
  • SQL_DOUBLE
  • SQL_FLOAT
  • SQL_INTEGER
  • SQL_LONGVARBINARY
  • SQL_LONGVARCHAR
  • SQL_REAL
  • SQL_SMALLINT
  • SQL_TIME
  • SQL_TIMESTAMP
  • SQL_TINYINT
  • SQL_VARBINARY
  • SQL_VARCHAR