Search Again: Re: Re: Minute Value doesn''''t change by using sysdate in interval of 64 Seconds. From: Jyoti.Rath@iflexsolutions.com Date: Sunday, January 18, 2004 Time: 8:41:20 pm Thanks.. I have got the result. _____ From: Marcio Portes [mailto:marcio.portes@uol.com.br] Sent: Sunday, 18 January 2004 5:39 PM To: oracle-list@digitalpoint.com Subject: [Oracle] RE: Minute Value doesn''t change by using sysdate in interval of 64 Seconds. Jyoti, I don't see that in my test. Are you sure have grant on dbms_lock package? I would like see your entire test copy/paste from sql*plus. Look mine. ops$marcio@MRP920> alter session set nls_date_format =3D 'dd/mm/yyyy - hh24:mi:ss'; Session altered. ops$marcio@MRP920> DECLARE 2 lStartTime date; 3 lEndTime date; 4 l_start number default dbms_utility.get_time; 5 6 BEGIN 7 select sysdate into lstarttime from dual; 8 sys.DBMS_LOCK.SLEEP (64); 9 select sysdate into lendtime from dual; 10 DBMS_OUTPUT.PUT_LINE('Elapsed :' || 11 to_char(round((dbms_utility.get_time-l_start)/100,2),'999.99') ); 12 dbms_output.put_line('First :' || lstarttime || ' Last:' || lendtime ); 13 END; 14 / Elapsed : 65.54 First :18/01/2004 - 09:53:31 Last:18/01/2004 - 09:54:37 PL/SQL procedure successfully completed. -- Marcio Portes marcio.portes@uol.com.br uin#112511323 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D From: Jyoti.Rath@iflexsolutions.com Date: Monday, November 10, 2003 Time: 4:32:32 am Hi DECLARE lStartTime VARCHAR2(30); lEndTime VARCHAR2(30); BEGIN SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY HH:MM::SS') INTO lStartTime FROM DUAL; =3D09 DBMS_OUTPUT.PUT_LINE('Start Time :: ' || lStartTime); DBMS_LOCK.SLEEP (64); =3D20 SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY HH:MM::SS') INTO lEndTime FROM DUAL; DBMS_OUTPUT.PUT_LINE('End Time :: ' || lEndTime); END; =3D20 =3D20 After execution the output should be=3D20 Start Time :: 04-11-2003 05:11::22 End Time :: 04-11-2003 05:12::26 But its is displaying .. Start Time :: 04-11-2003 05:11::22 End Time :: 04-11-2003 05:11::28 The minute value is not changing it is remaining same. Can anyone tell me why it is working like this... Jyoti Ranjan DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

Messages In This Thread: Re: Minute Value doesn''''t change by using sysdate in interval of 64 Seconds. by Marcio Portes on Jan 18, 2004 at 4:09:19 am Re: Re: Minute Value doesn''''t change by using sysdate in interval of 64 Seconds. by Jyoti.Rath@iflexsolutions.com on Jan 18, 2004 at 8:41:20 pm