Subject | Converting with parameters stored in variables? |
---|---|
Author | Check_Mail |
Post date | 2019-08-29T12:29:07Z |
Hello,
I get from a application the following
100
R10.3
Or
22.22
R10.3
Now I should take it into:
0000000100.000
And
0000000022.220
I think, I cannot simply (cast :input as :vartype) (vartype = ‘decimal(10.3)’
Also it will fortunately not work: cast(input as decimal(:v1,:v2) (v1 = 10 v2 = 3).
How can I realize it without dismantle the 10.3 and the 22.22?
Thank you.