想得到某一天的最早时间点和最晚时间点。比如今天的2010-4-30 00:00:01,2010-4-30 23:59:59。该怎么实现?请高手指教
------解决方案--------------------
- SQL code
select trunc(sysdate)+1/86400 early,trunc(sysdate)+1-1/86400 late from dual;
------解决方案--------------------
select trunc(sysdate)+1/86400 early,trunc(sysdate)+1-1/86400 late from dual;
------解决方案--------------------