Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E15754758DC for ; Fri, 31 May 2002 16:09:40 -0400 (EDT) Received: from c011.snv.cp.net (h003.c011.snv.cp.net [209.228.34.216]) by postgresql.org (Postfix) with SMTP id 9B67047545D for ; Fri, 31 May 2002 16:09:39 -0400 (EDT) Received: (cpmta 16518 invoked from network); 31 May 2002 13:09:30 -0700 Received: from 12.110.19.156 (HELO sherwinharris) by smtp.mstar.net (209.228.34.216) with SMTP; 31 May 2002 13:09:30 -0700 X-Sent: 31 May 2002 20:09:30 GMT From: "Sherwin Harris" To: Subject: DateStyle question Date: Fri, 31 May 2002 14:12:09 -0600 Message-ID: <001301c208df$725dbbf0$e8fcff0a@sherwinharris> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Archive-Number: 200205/121 X-Sequence-Number: 1253 My question is probably simpler than most of you deal with but: How do I change the datestyle of my database so that it is in the US style (or any other style for that matter)? I want it to start in the new style, not just change it with a SET command. Any comments or reasons why I should not do this are also welcome. Sherwin Harris