diff options
author | Kristian Lyngstol <kristian@bohemians.org> | 2016-05-18 20:25:35 +0200 |
---|---|---|
committer | Kristian Lyngstol <kristian@bohemians.org> | 2016-05-18 20:25:35 +0200 |
commit | fd5139ed9b56b3122d73d397482ecd6fd8ffbe26 (patch) | |
tree | 24d3e639f1e3bd46c299f72dee61b5fb89035f11 /web/api/read/oplog | |
parent | 69fe67df43cd17c47c03f3fe750d2478c3f2b8cc (diff) |
Remove comments from code in place of oplogs
Diffstat (limited to 'web/api/read/oplog')
-rwxr-xr-x | web/api/read/oplog | 2 |
1 files changed, 1 insertions, 1 deletions
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; |