Search Again: Re: Minute Value doesn''''t change by using sysdate in interval of 64 Seconds. From: Marcio Portes Date: Sunday, January 18, 2004 Time: 4:09:19 am 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

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