Hello,
I need a integer format with different decimal places
The integer should have 6 diggits. (or 7 or 8)
Example (6-diggits)
input -> output
123456.789 -> 123456
1234.56789 -> 1234.56
12.3456789 -> 12.3456
but when it is more then 10^6 then
12345678.9 -> 12345678
Is there a pg function for this task?
Franz