Hi Gurus,
I have a table with datatype as bitstrings
create table test_a (b bit(3));
insert into test_a values ('111');
This will convert a bit to a number
==========================
select to_number((substring(b,1,1)::int),9)+3 from test_a;
How will I convert a Number to a bit
----------------------------------
insert into test_a values (to_char(1,'9'));
ERROR: column "b" is of type bit but _expression_ is of type text
HINT: You will need to rewrite or cast the _expression_.
Please help me
regards
skarthi
i'm making a difference. Make every IM count for the cause of your choice. Join Now.
