Hi all & sorry for the vague topic title.
I need to store a date that will always be x years before the current date. Is doing something like
select sysdate -x from dual
Going to result in any weird issues down the road?
Also, because I haven't explicitly specified the date, when queried, will the value always be sysdate - x (What I want to happen) as opposed to dateRowWasCreated - x?
Any pointers would be great - as you can tell I'm quite / very new to Oracle.