--- trunk/sql/schema.sql	2005/07/23 19:21:07	27
+++ trunk/sql/schema.sql	2005/07/24 09:27:26	28
@@ -84,10 +84,10 @@
 
 create view pgbits_articles as select
 	issue,
-	entries_pgbits.date as issue_date,
+	date(entries_pgbits.date) as issue_date,
 	ititle,
 	mytitle,
-	items_pgbits.date as date
+	date(items_pgbits.date) as date
 from items_pgbits
 join entries_pgbits on entry_id = entries_pgbits.id ;