@634

Oracle PL/SQL - TIPS

Advertisement

YYYYMM‚Ì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ƒg

E634ƒgƒbƒvƒy[ƒW
E‚±‚̃JƒeƒSƒŠ‚̃gƒbƒvƒy[ƒW‚É–ß‚é
E634ƒ‰ƒ{
   UIƒRƒŒƒNƒVƒ‡ƒ“ƒMƒƒƒ‰ƒŠ[

ƒTƒCƒgŒŸõ

Google

Web ƒTƒCƒg“à

Y!ƒƒO[ƒ‹