I am facing some challenge to formatting the Float data type in Postgresql DB.
I have order table after I sum up it returns the rows like this,
3.469384874497004E9
But expected data should be 3469384874.97. How to return the data like this, as I have to concat this values for some other business purpose.
Try this,
So we need to cast as decimal to reflect all data as it is. So basically this will take all integers before precision and after precision as well.