Sql Query Data Format

[invoso.com]

using sql query I found problem

 

postgres sql query:

SELECT round(((connection_cost*1.00)/100),2)

FROM ...

WHERE ...

 

 

postgres client interpretation: (connection_cost*1.00)/100 = 0.01

 

but VG retuns: (connection_cost*1.00)/100 = 0,03000000000000000000

 

 

I try other method:

 

round(((connection_cost*1.00)/100),2) = 0.01

 

VG retuns: round(((connection_cost*1.00)/100),2) = 0,01

 

how to change comma (,) to (.)?

 

 

 

 

 

[SupportTeam]

Could you please post vgEngine trace capturing the call.

 

(Please .ZIP up traces before posting them)

 

Which version of Postgres database are you using?