|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
用trunc 函数 得到下两分钟
select trunc(sysdate+2/(24*60),'mi') from dual;
|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
|
select sysdate+2/(24*60) from dual;
|
用trunc 函数 得到下两分钟
select trunc(sysdate+2/(24*60),'mi') from dual;

被折叠的 条评论
为什么被折叠?