Index: openacs-4/packages/ecommerce/www/admin/orders/fulfillment.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/fulfillment.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/fulfillment.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/fulfillment.xql	22 Jul 2001 06:20:30 -0000	1.2
@@ -4,7 +4,7 @@
 <fullquery name="orders_select">      
       <querytext>
       
-    select o.order_id, o.confirmed_date, o.order_state, o.shipping_method,
+    select o.order_id, to_char(o.confirmed_date, 'YYYY-MM-DD') as confirmed_date, o.order_state, o.shipping_method,
            u.first_names, u.last_name, u.user_id
       from ec_orders_shippable o, cc_users u
      where o.user_id=u.user_id