select round( sysdate, month) from dual; in this query if we use number instead of sysdate.. it shows error.. why? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

select round( sysdate, month) from dual; in this query if we use number instead of sysdate.. it shows error.. why?

4th Oct 2016, 7:08 PM
S.Akbar Sheriff
2 Answers
+ 1
The round function has 2 parameters, round(column_name, decimals)
6th Oct 2016, 11:40 AM
Abdul Meyer
Abdul Meyer - avatar
0
it all depends on what the values are of sysdate, month & number
6th Oct 2016, 11:39 AM
Abdul Meyer
Abdul Meyer - avatar