small improvements

[webpac2] / sql / schema.sql

diff --git a/sql/schema.sql b/sql/schema.sql
index e1d728d..fc9dc3a 100644 (file)
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -84,10 +84,10 @@ create table items_pgbits (
 
 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 ;