summaryrefslogtreecommitdiffstats
path: root/raddb/mods-config/sql/counter/sqlite/expire_on_login.conf
diff options
context:
space:
mode:
Diffstat (limited to 'raddb/mods-config/sql/counter/sqlite/expire_on_login.conf')
-rw-r--r--raddb/mods-config/sql/counter/sqlite/expire_on_login.conf2
1 files changed, 1 insertions, 1 deletions
diff --git a/raddb/mods-config/sql/counter/sqlite/expire_on_login.conf b/raddb/mods-config/sql/counter/sqlite/expire_on_login.conf
index f4e95a5..6c1c086 100644
--- a/raddb/mods-config/sql/counter/sqlite/expire_on_login.conf
+++ b/raddb/mods-config/sql/counter/sqlite/expire_on_login.conf
@@ -1,5 +1,5 @@
query = "\
- SELECT GREATEST(strftime('%%s', NOW()) - strftime('%%s', acctstarttime), 0) AS expires \
+ SELECT MAX(strftime('%%s', NOW()) - strftime('%%s', acctstarttime), 0) AS expires \
FROM radacct \
WHERE username = '%{${key}}' \
ORDER BY acctstarttime \