Extracting string from sysdate. 1

[EdRev]

The format of my sysdate is in 'DD-MON-YY' (i.e 25-MAR-03).
I want to extract the following rom this date string.

strMonth = MAR
intMonth = 03
strYear = 2003
intYear = 3

Can anybody show me the function(s) to do the above including the declaration section.

 

[51m0n]

try this (i did not test it, writing it on the fly):

declare

strMonth varchar2(3);
intMonth number;
strYear number;
intYear number;
begin
strMonth := to_char(sysdate, 'MON');
intMonth := to_char(sysdate, 'mm');
strYear := to_char(sysdate, 'yyyy');
intYear := mid(to_char(sysdate, 'yy'), 2, 1);
end;
--
regards,
Simon

 

[EdRev]

Thanks a lot Simon!