Re: Elapsed Time
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Fri, 19 May 2006 23:30:11 +0200
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
--
//www.freelists.org/webpage/oracle-l
--
Best regards,
Alex Gorbachev
http://oracloid.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
