DECLARE
/*This program coverts a date from one fomat eg 1/31/10
into another format eg January 31,2010 */

/*declaring variables
assign a date that is in one format*/
EXAMPLE_DATE  DATE := TO_DATE(' 1/31/06',' MM/DD/YY' );
/*finding the position of where the forward slash are*/
position_finder NUMBER := INSTR(EXAMPLE_DATE,'/');


BEGIN
	/*Output example_date in the other format*/
	DBMS_OUTPUT.PUT_LINE(TO_CHAR(EXAMPLE_DATE));
	DBMS_OUTPUT.PUT_LINE(TO_CHAR(position_finder));
END;

SQL> DECLARE
  2  /*This program coverts a date from one fomat eg 1/31/10
  3  into another format eg January 31,2010 */
  4  
  5  /*declaring variables
  6  assign a date that is in one format*/
  7  EXAMPLE_DATE  DATE := TO_DATE(' 1/31/06',' MM/DD/YY' );
  8  /*finding the position of where the forward slash are*/
  9  position_finder NUMBER := INSTR(EXAMPLE_DATE,'/');
 10  
 11  
 12  BEGIN
 13   /*Output example_date in the other format*/
 14   DBMS_OUTPUT.PUT_LINE(TO_CHAR(EXAMPLE_DATE));
 15   DBMS_OUTPUT.PUT_LINE(TO_CHAR(position_finder));
 16  END;
 17  /
31/01/2006 00:00:00
3

PL/SQL procedure successfully completed.