DB Tool Issue

tapan1986tapan1986 Posts: 27

I am using DB tool to retrieve data from SQL Server.
In DB the value is 0.0000003 but while returning in soatest it shows as below

Not sure about the conversion.Could you pls check and confirm.



  • benken_parasoftbenken_parasoft Posts: 1,001 ✭✭✭
    edited December 2019

    Isn't 0.0000003 is the same as 3.00000E-7? I don't think the database stores the value as text but as a floating point number. So, neither textual representation is incorrect.

    If, for example, you want to validate a floating point value then you could do a numerical comparison (not a text comparison). You could do this with the "Numeric Assertion" from the XML Assertor, for example.

Sign In or Register to comment.