Oracle之:Function :numberToDate()

mac2022-06-30  101

create or replace function numberToDate(i_date in number) return date is v_date number; result date ; begin v_date := i_date; if v_date = 0 then v_date := null; end if; result := TO_DATE(v_date, 'J'); return result; end numberToDate;

转载于:https://www.cnblogs.com/bilaisheng/p/10210986.html

最新回复(0)