summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Misc.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNDB/DB/Misc.pm')
-rw-r--r--lib/VNDB/DB/Misc.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Misc.pm b/lib/VNDB/DB/Misc.pm
index 1c21675e..eeb860b0 100644
--- a/lib/VNDB/DB/Misc.pm
+++ b/lib/VNDB/DB/Misc.pm
@@ -127,7 +127,8 @@ sub dbRevisionGet {
);
my @select = (
- qw|c.id c.type c.added c.requester c.comments c.rev c.causedby|,
+ qw|c.id c.type c.requester c.comments c.rev c.causedby|,
+ q|extract('epoch' from c.added) as added|,
$o{what} =~ /user/ ? 'u.username' : (),
$o{what} =~ /item/ ? (
'COALESCE(vr.vid, rr.rid, pr.pid) AS iid',