summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration/usercerts.c
diff options
context:
space:
mode:
Diffstat (limited to 'database/sqlite/administration/usercerts.c')
-rw-r--r--database/sqlite/administration/usercerts.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/usercerts.c b/database/sqlite/administration/usercerts.c
index 8e654ab..c6f368e 100644
--- a/database/sqlite/administration/usercerts.c
+++ b/database/sqlite/administration/usercerts.c
@@ -81,7 +81,7 @@ xmlDoc *usercerts_search(eurephiaCTX *ctx, eDBfieldMap *where_m, const char *sor
}
res = sqlite_query_mapped(ctx, SQL_SELECT,
- "SELECT uicid, ucs.uid AS uid, certid, ucs.registered AS registered,"
+ "SELECT uicid, ucs.uid AS uid, certid, locdt(ucs.registered) AS registered,"
" ucs.accessprofile AS accessprofile, access_descr,"
" username, "
" common_name, organisation, email, lower(digest), depth "