5 Replies Latest reply: Dec 23, 2012 3:53 PM by Srini Chavali-Oracle RSS

    I want to reset my date to this format: 12/31/2012 11:59:59 PM .. please ad

    979256
      I want to reset my date to this format: 12/31/2012 11:59:59 PM - see code below:

      DECLARE
      v_latest_close DATE;
      BEGIN
      v_latest_close := TO_DATE ('12/31/2012 23:59:59 ','MM/DD/YYYY HH24:MI:SS');

      DBMS_OUTPUT.PUT_LINE('The new date format is : '|| v_latest_close);

      END;

      the code above displays only : 12/31/2012 instead of 12/31/2012 11:59:59 PM

      Please advise

      Hope