diff options
Diffstat (limited to 'database/sqlite/administration/certificates.c')
-rw-r--r-- | database/sqlite/administration/certificates.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/certificates.c b/database/sqlite/administration/certificates.c index 8db12ff..93518b6 100644 --- a/database/sqlite/administration/certificates.c +++ b/database/sqlite/administration/certificates.c @@ -87,7 +87,7 @@ static xmlDoc *certificate_list(eurephiaCTX *ctx, eDBfieldMap *srch_map, const c res = sqlite_query_mapped(ctx, SQL_SELECT, "SELECT depth, lower(digest), common_name, organisation, email, " - " registered, certid" + " locdt(registered), certid" " FROM openvpn_certificates", NULL, srch_map, sortkeys); if( sqlite_query_status(res) != dbSUCCESS ) { eurephia_log(ctx, LOG_ERROR, 0, "Could not query the certificate table"); |