Provide you some of the PL/SQL example i have experienced
$ date --date='2 year ago' # past$ date --date='3 years' # go into future$ date --date='2 days' # future$ date --date='1 month ago' # past$ date --date='2 months' # future