diff options
Diffstat (limited to 'database/sqlite/administration/usercerts.c')
-rw-r--r-- | database/sqlite/administration/usercerts.c | 2 |
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 " |