You can translate the question and the replies:


I need to converter this TO_CHAR(9999, 'fm00000') for a vql. Is that possible? Thank you. Regards
17-04-2024 09:54:53 -0400

1 Answer

Hi, Denodo provides the `CAST` function, which allows you to convert data from one type to another. The syntax is as follows: `CAST( <vdp data type:text>, <value:expression> )` where `vdp data type` is the data type to which you want the value to be converted, and `value` is the value to be converted. I would refer to the solution given in this similar [community question]( Additionally, I would look into [Conversion Functions]( guide for more information about the possible type conversions. Hope this helps!
Denodo Team
17-04-2024 15:37:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here