How to convert a decimal number into an integer in an SQL query

Asked

Viewed 14 times

-1

I am making a query in SQL in my database and is returning values in decimal. Is there a function to round the values or turn them into integers?

sql dbeaver
  • 1

    yes, each database has its conversion functions, already consulted the documentation?

  • It will be some variant of ROUND() but as the functions vary from SQL database to another, it would have to include in the question which specific database. Even better: look for the documentation of your bank that you should find easily on rounding.

No answers

Browser other questions tagged sql dbeaver

You are not signed in. Login or sign up in order to post.