Changes between Version 4 and Version 5 of INTEGRATING operation


Ignore:
Timestamp:
Dec 6, 2010 1:12:22 PM (14 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • INTEGRATING operation

    v4 v5  
    7070select * from wrbd.operation_op where extract('year' from op_date) !=op_year; 
    7171-- modification des dates concernées 
    72 select to_date(cast(op_year AS text)||' '||cast(extract('month' from op_date) AS text)||' '||cast(extract('day' from op_date) AS text),'YYYY MM DD') from wrbd.operation_op where extract('year' from op_date) !=op_year; 
    7372update wrbd.operation_op set op_date=to_date(cast(op_year AS text)||' '|| 
    7473        cast(extract('month' from op_date) AS text)||' '||