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
3.00000E-7

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

Tagged:

Comments

  • benken_parasoftbenken_parasoft Posts: 890 ✭✭✭
    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.