Changes between Version 5 and Version 6 of INTEGRATING operation

Timestamp:

Dec 6, 2010 1:13:50 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING operation

@@ -70 +70 @@
 select * from wrbd.operation_op where extract('year' from op_date) !=op_year;
 -- modification des dates concernées
-update wrbd.operation_op set op_date=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')
-        where extract('year' from op_date) !=op_year;
+update wrbd.operation_op set op_date=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'
+        ) where extract('year' from op_date) !=op_year;
 }}}