不理解楼主 需求 select dbms_utility.get_time from dual; 可否
This function determines the current time in 100th's of a second. This subprogram is primarily used for determining elapsed time. The subprogram is called twice – at the beginning and end of some process – and then the first (earlier) number is subtracted from the second (later) number to determine the time elapsed.
SYSTIMESTAMP TO_CHAR(SYSTIMESTAMP,'FF')
-------------------------------------------------------------------------------- --------------------------
30-12月-10 11.20.18.656000 上午 +08:00 656000
SQL>
SYSTIMESTAMP TO_CHAR(SYSTIMESTAMP,'FF1')
-------------------------------------------------------------------------------- ---------------------------
30-12月-10 11.24.48.671000 上午 +08:00 6
SQL> select systimestamp,to_number('0.'||to_char(systimestamp,'FF9')) from dual;
SYSTIMESTAMP TO_NUMBER('0.'||TO_CHAR(SYSTIM
-------------------------------------------------------------------------------- ------------------------------
30-12月-10 11.36.39.265000 上午 +08:00 0.265
SQL>
select dbms_utility.get_time from dual;
可否
----------
1293713186SQL> select trunc(86400*(to_date('20101230 11:07:07', 'yyyymmdd hh24:mi:ss') - to_date('19700101', 'yyyymmdd'))) seconds from dual; SECONDS
----------
1293707227
或者to_char(sysdate)=''