Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Elapsed Time
Well, not realy coz instead of sysdate there is number of seconds.
2006/5/19, rjamya <rjamya_at_gmail.com>:
> 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-l
>
>
>
-- Best regards, Alex Gorbachev http://oracloid.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 19 2006 - 16:30:11 CDT
![]() |
![]() |