You can translate the question and the replies:

How can i use oracle function TO_CHAR in denodo

I need to convert NUMBER to STRING, I tried using " cast(data_type, value) " but it's showing invalid. Does denodo have any inbuilt function similar to TO_CHAR() as in Oracle.
string conversion
user
08-02-2017 05:36:15 -0500
code

1 Answer

Hi, In virtual data port, text data type represents a character strings. I was able to convert a value of numeric data type to string by using the Cast function available in VDP. Syntax: cast(cast-type, expression) Example: cast('text',employee_id) You can also refer the section “Type Conversion Functions” in DENODO VIRTUAL DATAPORT 6.0 ADVANCED VQL GUIDE for more examples. Hope this helps.
Denodo Team
10-02-2017 01:10:22 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here