7 Replies Latest reply on Jan 2, 2013 10:01 PM by Etbin

    update op_date's 'YYYY; value in to CL_date 'YYYY' value

    user10069916
      Table Name : Audit
      ID     Op_date          Cl_Date
      1     12/02/2014     15/02/2012
      2     4/01/2071     16/12/2012

      Op_date datatype date (dd/mm/yyyy)
      cl_date datatype date (dd/mm/yyyy)

      Please help me to update op_date's 'YYYY; value in to CL_date 'YYYY' value

      final resulet would be

      ID     Op_date          Cl_Date
      1     12/02/2012     15/02/2012
      2     4/01/2012     16/12/2012

      Please help me.