The following commit has been merged in the master branch:
commit 67a52d1cbb401af0d56d08df9c9503653de24a57
Author: Michal Čihař <mci...@novell.com>
Date: Thu Mar 3 12:09:10 2011 +0100
Use ODBC 4 for now_plus
diff --git a/smsd/services/sql.c b/smsd/services/sql.c
index d213c3e..6b3d680 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 CURRENT_TIMESTAMP()} + INTERVAL %d SECOND";
+const char now_plus_odbc[] = "{ fn TIMESTAMPADD('SQL_TSI_SECOND', %d, {fn
CURRENT_TIMESTAMP()}) }";
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')";
--
Gammu
_______________________________________________
Gammu-svn mailing list
Gammu-svn@lists.cihar.com
https://lists.cihar.com/cgi-bin/mailman/listinfo/gammu-svn
