Hi, I’m trying to round the values from a field in which I have salaries, so I want to use the ROUND function. However I am getting a syntax error. Due there are some minor differences between SQL and HSQLDB, it seems that I am doing something wrong.
This is my code:
SELECT “Nombre”, “Apellido1ero”, “SalarioBruto_EUR”
ROUND (“SalarioBruto_EUR”, 0) AS “SalarioRedondeado”
It produce a SQL Error 1000, Syntax error.
The fields are in Spanish, but are easy to understand Nombre (Name), Apellido1ero (FirstName), SalarioBruto_EUR (GrossSalary_EUR)
What I want is to round the values of SalarioBruto_EUR and show these values rounded as SalarioRedondeado, however I am getting the syntax error.
Due there are differences between SQL and HSQLDB, I’d really appreciate your help to let me know what am I typing wrong