Good day. There is a column А (data type varchar(30) ) and a column В (data type double ). I write in is calculated as a column В this line cast(А as double) . When I start to enter data into a table, an error occurs. Is it possible to convert varchar data type to double data type?
angry
5,855 15 56 171
prapar prapar
23 ten
|
1 answer
The type must not be DOUBLE, but DOUBLE PRECISION
select cast('0.5' as DOUBLE PRECISION) from RDB$ROLES 
toxicdream toxicdream
1,022 five 12
- onealthough this is an implicit conversion, it still helped me find my mistake. thanks for the answer. - prapar
|