Hello,
I have the following SProc where <one month> is the syntax i am after. I think the code is fairly self explanatory, but if anything is not clear then please ask :)
CREATE or REPLACE PROCEDURE &HKResourceDB_Schema_Name..UpdateSubscriptionDates
(
aGroupID NUMBER
)
AS
BEGIN
UPDATE HKGroup
SET SubscriptionStarted = CAST(SYS_EXTRACT_UTC(LOCALTIMESTAMP) AS DATE),
SubscriptionEnded = CAST(SYS_EXTRACT_UTC(LOCALTIMESTAMP) AS DATE) + <one month>
WHERE ID = aGroupID;
END UpdateSubscriptionDates;
/