diff options
| author | randomdan <randomdan@localhost> | 2010-06-11 17:30:47 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-06-11 17:30:47 +0000 |
| commit | da666591623fd606e2d83812a0a65f4005c9a42f (patch) | |
| tree | 9118c5360d613169da9cae2ae46b40ed495b51e1 | |
| parent | Add package page using subqueries (diff) | |
| download | gentoobrowse-da666591623fd606e2d83812a0a65f4005c9a42f.tar.bz2 gentoobrowse-da666591623fd606e2d83812a0a65f4005c9a42f.tar.xz gentoobrowse-da666591623fd606e2d83812a0a65f4005c9a42f.zip | |
Fix age field of new ebuilds
| -rw-r--r-- | gentoobrowse/views/newebuilds.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/views/newebuilds.xml b/gentoobrowse/views/newebuilds.xml index d27ee70..0ba5886 100644 --- a/gentoobrowse/views/newebuilds.xml +++ b/gentoobrowse/views/newebuilds.xml @@ -3,7 +3,7 @@ <xi:include href="../datasources/postgres.xml" /> <sqlview name="newebuilds" recordname="ebuild" datasource="postgres"> <sql> - SELECT filename, EXTRACT('day' FROM NOW() - f.firstseen) AS age, description, + SELECT filename, EXTRACT('day' FROM NOW()) - EXTRACT('day' FROM f.firstseen) AS age, description, moddate, p.name AS pkgname, c.name AS catname FROM ebuilds e, files f, packages p, categories c WHERE e.ebuildid = f.fileid |