What does the trunc to be sure and what other uses may have taking this example?
1 answer
4
To TRUNC() just discard the decimal part and keep the whole part.
In this case it doesn’t matter to see something like "2.75". With the function would be only "2 years", which is debatable because it is more to 3 years than 2. So the ROUND() might be more interesting.
Much simpler than I expected =)) already makes sense, thank you
I understand that the ROUND( ) can also be applied but the question asks for shows how many years ago was edited, so "2,75 years" are 2 years, if I am not mistaken with the ROUND( ) would result 3 years
Much simpler than I expected =)) already makes sense, thank you
– Droopy
I understand that the ROUND( ) can also be applied but the question asks for shows how many years ago was edited, so "2,75 years" are 2 years, if I am not mistaken with the ROUND( ) would result 3 years
– Droopy
@Droopy so I said it’s debatable, it depends on the criteria
– Maniero