From f468603baae1393e126f708eeab2ff272ee55081 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Michal=20=C4=8Ciha=C5=99?= <mcihar@novell.com>
Date: Thu, 3 Mar 2011 13:45:22 +0100
Subject: [PATCH] Okay, TIMESTAMPADD is not way to go

---
 smsd/services/sql.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/smsd/services/sql.c b/smsd/services/sql.c
index 469207654..972aa9a41 100644
--- a/smsd/services/sql.c
+++ b/smsd/services/sql.c
@@ -29,7 +29,7 @@
 #include "../core.h"
 #include "../../helper/string.h"
 
-const char now_plus_odbc[] = "{ fn TIMESTAMPADD('SQL_TSI_SECOND', %d, {fn CURRENT_TIMESTAMP()}) }";
+const char now_plus_odbc[] = "{fn CURRENT_TIMESTAMP()} + INTERVAL %d SECOND";
 const char now_plus_mysql[] = "(NOW() + INTERVAL %d SECOND) + 0";
 const char now_plus_pgsql[] = "now() + interval '%d seconds'";
 const char now_plus_sqlite[] = "datetime('now', '+%d seconds')";
-- 
2.11.4.GIT