From da666591623fd606e2d83812a0a65f4005c9a42f Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Fri, 11 Jun 2010 17:30:47 +0000
Subject: Fix age field of new ebuilds

---
 gentoobrowse/views/newebuilds.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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
-- 
cgit v1.2.3