summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration/firewalladmin.c
diff options
context:
space:
mode:
Diffstat (limited to 'database/sqlite/administration/firewalladmin.c')
-rw-r--r--database/sqlite/administration/firewalladmin.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/firewalladmin.c b/database/sqlite/administration/firewalladmin.c
index fd34183..b10c5d0 100644
--- a/database/sqlite/administration/firewalladmin.c
+++ b/database/sqlite/administration/firewalladmin.c
@@ -81,7 +81,7 @@ xmlDoc *fwadmin_search(eurephiaCTX *ctx, eDBfieldMap *fmap) {
"SELECT access_descr, fw_profile, accessprofile, "
" uid, username, "
" uac.certid, common_name, organisation, "
- " email, lower(digest), c.registered, uicid "
+ " email, lower(digest), locdt(c.registered), uicid "
" FROM openvpn_accesses"
" LEFT JOIN openvpn_usercerts uac USING (accessprofile)"
" LEFT JOIN openvpn_users USING (uid)"