From fd5139ed9b56b3122d73d397482ecd6fd8ffbe26 Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol Date: Wed, 18 May 2016 20:25:35 +0200 Subject: Remove comments from code in place of oplogs --- web/api/read/oplog | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'web/api/read/oplog') diff --git a/web/api/read/oplog b/web/api/read/oplog index d56890a..92511bb 100755 --- a/web/api/read/oplog +++ b/web/api/read/oplog @@ -6,7 +6,7 @@ use nms::web; use strict; use warnings; -my $query = $nms::web::dbh->prepare('select id,time as timestamp,extract(hour from time) as h, extract(minute from time) as m,systems,username,log from oplog order by id desc;'); +my $query = $nms::web::dbh->prepare('select id,date_trunc(\'second\',time) as timestamp,extract(hour from time) as h, extract(minute from time) as m,systems,username,log from oplog order by id desc;'); $query->execute(); while (my $ref = $query->fetchrow_hashref()) { my %meh; -- cgit v1.2.3