Search Again: Minute Value doesn''t change by using sysdate in interval of 64 Seconds. 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; =09 DBMS_OUTPUT.PUT_LINE('Start Time :: ' || lStartTime); DBMS_LOCK.SLEEP (64); =20 SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY HH:MM::SS') INTO lEndTime FROM DUAL; DBMS_OUTPUT.PUT_LINE('End Time :: ' || lEndTime); END; =20 =20 After execution the output should be=20 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. ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: Minute Value doesn''t change by using sysdate in interval of 64 Seconds. by Jyoti.Rath@iflexsolutions.com on Nov 10, 2003 at 4:32:32 am