You can translate the question and the replies:

ORACLE TO VQL

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

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](https://community.denodo.com/answers/question/details?questionId=90670000000XcumAAC). Additionally, I would look into [Conversion Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/conversion_functions/conversion_functions) guide for more information about the possible type conversions. Hope this helps!
Denodo Team
17-04-2024 15:37:30 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here