Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 47E079FB39B for ; Mon, 5 Mar 2007 08:16:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 20589-10 for ; Mon, 5 Mar 2007 08:16:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 374E79FB32B for ; Mon, 5 Mar 2007 08:16:37 -0400 (AST) Received: from [172.20.101.163] ([12.169.47.3]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l25CGCbT029429; Mon, 5 Mar 2007 04:16:13 -0800 Message-ID: <45EC0A0B.8020907@commandprompt.com> Date: Mon, 05 Mar 2007 04:16:11 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql-general@postgresql.org, rod@iol.ie Subject: Re: date format References: <200703041247.05097.garry@schoolteachers.co.uk> <200703041616.08699.garry@schoolteachers.co.uk> <45EAF0D5.1030707@iol.ie> <200703051104.58974.peter_e@gmx.net> In-Reply-To: <200703051104.58974.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 05 Mar 2007 04:16:13 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.506 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/256 X-Sequence-Number: 110446 Peter Eisentraut wrote: > Am Sonntag, 4. März 2007 17:16 schrieb Raymond O'Donnell: > >> Probably a silly question, but did you remember to restart the server >> after changing the datestyle setting? >> > > You don't need to do that. > I didn't really explain my point here. You an use datestyle from a session, or you can reload the server. You do not need to *restart*. However, he didn't mention if he had done any of that. He just said he set it which doesn't really mean anything if he didn't change it from the setting or reload the server. J