thanks Harun for your example.. however, I am still stuck.. initially I have thought it is due to the date with time that interfere with the date_add, and I make it with to_date, however, the same error message appear.

With the next statement, it gives error below:

Appreciate if you could point me to the error. Thanks.