My float value has 5.0000E-05 I want to convert E-05 to decimal points?

[Ray0801]

Is it possible to display all the values in float as decimal points ,

I dont want it to be displayed as Power of E ,is it possible

I am using Talend Open Studio 7.3.1

I am loading my data into Float datatype length 30 ,into Sql Server Database

[Anonymous · Accepted solution]

Are you seeing the values like this in your SQL Server queries? If this is the case, you will need to query with a cast. Something like this......

select cast([yourColumn] as decimal(18,18))

from yourTable

Talend is sending SQL Server the number. It doesn't care about how it is displayed. Nothing you do in Talend will change how SQL Server represents the number.