Index: openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 18 Nov 2001 18:57:58 -0000 1.1
+++ openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 18 Dec 2001 19:28:00 -0000 1.2
@@ -4,20 +4,20 @@
- current_timestamp between to_date(attributes.release_date, 'YYYY-MM-DD') and
- to_date(attributes.archive_date, 'YYYY-MM-DD')
+ current_timestamp between to_date(attributes.release_date, 'Month DD, YYYY') and
+ to_date(attributes.archive_date, 'Month DD, YYYY')
- current_timestamp >= to_date(attributes.archive_date, 'YYYY-MM-DD')
+ current_timestamp >= to_date(attributes.archive_date, 'Month DD, YYYY')
- to_date(attributes.release_date, 'YYYY-MM-DD') desc
+ to_date(attributes.release_date, 'Month DD, YYYY') desc