You can translate the question and the replies:

Data precision

Hi team, I need help with few questions listed below: I am connecting to SQL server and for the numeric(19,8) datatype the decical value is lost at denodo side. How to maintain the decimal precision at denodo side? SQL side uptp 8 decimal places – 550000.00000000 7185205.58000000 denodo side all the trailing zeros are truncated – 550000 7185205.58 secondly, the datetime field in sql has precison upto nano second. How to maintain the datetime value upto nano second level? SQL- 2013-09-26 12:40:07.000 but in denodo side its trimming the nano second value denodo - 2013-09-26 12:40:07 Thanks
user
28-05-2021 14:57:50 -0400

3 Answers

Hi, You could try [creating a base view from a query](https://community.denodo.com/kb/en/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option) to format the column containing the decimals. Any functions used here are delegated to the underlying data source, allowing you to take advantage of SQL Server’s functions. For more information, you can refer to this similar [Q&A thread](https://community.denodo.com/answers/question/details?questionId=9060g000000TQmXAAW&title=Need+3+digits+after+decimal). But instead of using the TO_CHAR function which is available in Oracle SQL Developer, you could try using the FORMAT function from SQL Server to specify the decimal places. For example: ``` SELECT FORMAT(<column_name>, 'N8') FROM <table_name> ``` Where ‘N8’ is the precision specifier for 8 decimal places. If this doesn’t work, you could also try creating a custom Java-based function using the Denodo4E extension. For more information on creating custom functions, you can refer to this guide: [Developing Custom Functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_custom_functions/developing_custom_functions). Hope this helps!
Denodo Team
01-06-2021 17:45:12 -0400
Thanks team. I followed all the steps mentioned in another post on how to add com.denodo.vdb.admin.stripTrailingZeros=false in the property file. But this doesn't resolve the issue. How to proceed further with this approach?
user
01-06-2021 18:23:28 -0400
Hi, I believe that installing the latest update and then making the configuration changes to VDBAdminConfiguration.properties will allow you to see the trailing zeros for decimal places. Hope this helps!
Denodo Team
21-06-2021 11:12:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here