Re: Elapsed Time

Well, not realy coz instead of sysdate there is number of seconds.

2006/5/19, rjamya <rjamya@xxxxxxxxx>:

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-l

References:
- Elapsed Time
  - From: Goulet, Dick
- RE: Elapsed Time
  - From: Mercadante, Thomas F \(LABOR\)
- Re: Elapsed Time
  - From: rjamya

Other related posts: