Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Elapsed Time
select to_char(sysdate,'hh24') || ' hours ' || to_char(sysdate,'mi')
|| ' minutes ' || to_char(sysdate,'ss') || ' seconds ' from dual
/
something like this won't work???
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 19 2006 - 14:57:06 CDT
![]() |
![]() |