diff options
Diffstat (limited to 'lib/VNDB/DB/Misc.pm')
-rw-r--r-- | lib/VNDB/DB/Misc.pm | 3 |
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', |