Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Elapsed Time

Re: Elapsed Time

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 19 May 2006 23:30:11 +0200
Message-ID: <c2213f680605191430j288e7adbya95f66207cc1eb30@mail.gmail.com>


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-l
Received on Fri May 19 2006 - 16:30:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US