且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

创建一个函数来返回oracle中的当前日期和时间

更新时间:2023-11-23 21:37:46

As an actual function you could do:

create or replace function getSysdate
return date is

  l_sysdate date;

begin

  select sysdate
    into l_sysdate
    from dual;

  return l_sysdate;

end;
/

Which you could test in SQLPlus as:

TEST>select getSysdate() from dual;

GETSYSDATE
----------
2010-01-04

Not sure why you would want this versus just having sysdate in your code. The Oracle date datatype includes the time portion.

上一篇 : :如何从Python日期减去一天?下一篇 : WPF:对列表框进行排序

相关阅读

推荐文章