Skip to Content Skip to Menu

[SOLVED] Profile value layout in a sql field

  • peli_m
  • peli_m
  • OFFLINE
  • Posts: 54
  • Thanks: 6
  • Karma: 0
9 years 6 months ago - 9 years 6 months ago #277031 by peli_m
Hello:

An sql field returns a numeric value with 4 decimal digits. Is there a way to show it only with two decimals?

And in other sql field who is doing some sums from integer numbers, it doesn't shows any decimal. Is it possible to show two decimal digits also (p.e. 123.00)?

Thank you,
Jose
Last edit: 9 years 6 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • peli_m
  • peli_m
  • OFFLINE
  • Posts: 54
  • Thanks: 6
  • Karma: 0
9 years 6 months ago #277051 by peli_m
Replied by peli_m on topic Profile value layout in a sql field
Hello,

I've found a solution with SELECT ROUND(SUM(`cb_imp_transport`),2) FROM...

Thank you.
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum