From 02a049703de6055f09f44f89a5a821814696ce32 Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
Date: Thu, 7 Oct 2010 03:58:28 -0700
Subject: Bug 602165: Change sql_interval to sql_date_math, in preparation for
 MS-SQL and SQLite support.

---
 userprefs.cgi | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'userprefs.cgi')

diff --git a/userprefs.cgi b/userprefs.cgi
index d15bcd13a..68c7d2748 100755
--- a/userprefs.cgi
+++ b/userprefs.cgi
@@ -57,8 +57,9 @@ sub DoAccount {
        Bugzilla::Token::CleanTokenTable();
 
         my @token = $dbh->selectrow_array(
-            "SELECT tokentype, issuedate + " .
-                    $dbh->sql_interval(MAX_TOKEN_AGE, 'DAY') . ", eventdata
+            "SELECT tokentype, " .
+                    $dbh->sql_date_math('issuedate', '+', MAX_TOKEN_AGE, 'DAY')
+                    . ", eventdata
                FROM tokens
               WHERE userid = ?
                 AND tokentype LIKE 'email%'
-- 
cgit v1.2.3-24-g4f1b