Oracle PL/SQL - TIPSAdvertisementYYYYMM‚ÌCHARŒ^€–ڂɑ΂·‚錎”‰‰ŽZ
date Œ^‚ɕϊ· ¨ add_months ŠÖ”‚ʼn‰ŽZ ¨ char Œ^‚ɕϊ·
declare
“–ŒŽ char(6);
‘OŒŽ char(6);
begin
“–ŒŽ := '200401';
‘OŒŽ := to_char(add_months(to_date(“–ŒŽ, 'YYYYMM'), 1), 'YYYYMM');
end;
Advertisement |
ƒVƒ‡[ƒgƒJƒbƒgE634ƒgƒbƒvƒy[ƒWE‚±‚̃JƒeƒSƒŠ‚̃gƒbƒvƒy[ƒW‚É–ß‚é E634ƒ‰ƒ{ UIƒRƒŒƒNƒVƒ‡ƒ“ƒMƒƒƒ‰ƒŠ[ ƒTƒCƒgŒŸõY!ƒƒO[ƒ‹ |