summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Misc.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-09 09:57:22 +0200
committerYorhel <git@yorhel.nl>2009-08-09 10:12:06 +0200
commitf0417c6752873c4d6191c7b5f90ac4e44853fd55 (patch)
treecfd3d7033c3564e04ac2f8c5458683b64f68f485 /lib/VNDB/DB/Misc.pm
parentbf4ee54dbc1a3d6a358883baedde7602a8232da4 (diff)
Converted changes.added to timestamptz
That was the last one. I hope I haven't forgotten to update anything.
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',