7 Replies Latest reply: Jan 2, 2013 4:01 PM by Etbin RSS

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

    770322
      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.