SQLite Forum

How to convert the data type of the new column in the view?
table like this:
CREATE TABLE t_spotprice
  tradingday       TEXT(20),
  product_name     TEXT(30),
  base_span        REAL DEFAULT 0,
  base_price_ratio REAL DEFAULT 0,
  spot_price       REAL DEFAULT 0,
  future_price     REAL DEFAULT 0
create a view like this:

CREATE VIEW 'test1111' AS
     (SUM(future_price)) as fp2
  FROM t_spotprice
  WHERE tradingday = 20200103;

The result of view 'test1111' is  is correct!!,but the datatype of fp2 in the view 
 of 'test1111' is unknown.

can I convert to REAL?