[Erp5-report] r25263 - /erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql

[nobody at svn.erp5.org]

Author: vincent
Date: Thu Jan 22 14:12:03 2009
New Revision: 25263

URL: http://svn.erp5.org?rev=25263&view=rev
Log:
Use DATE_SUB.

Modified:
    erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql?rev=25263&r1=25262&r2=25263&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_timeShift.zsql [utf8] Thu Jan 22 14:12:03 2009
@@ -12,8 +12,8 @@
 UPDATE
   message_queue
 SET
-  date = date - <dtml-sqlvar delay type="int">,
-  processing_date = processing_date - <dtml-sqlvar delay type="int">
+  date = DATE_SUB(date, INTERVAL <dtml-sqlvar delay type="int"> SECOND),
+  processing_date = DATE_SUB(processing_date, INTERVAL <dtml-sqlvar delay type="int"> SECOND)
 WHERE
   1 = 1
 <dtml-if expr="processing_node is not None">