X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 14D1B9DCB5E for ; Thu, 8 Dec 2005 13:45:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85359-04 for ; Thu, 8 Dec 2005 13:44:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ll.mit.edu (LLMAIL.LL.MIT.EDU [129.55.12.40]) by postgresql.org (Postfix) with ESMTP id 9F5849DCB45 for ; Thu, 8 Dec 2005 13:44:55 -0400 (AST) Received: (from smtp@localhost) by ll.mit.edu (8.12.10/8.8.8) id jB8HirDn015700 for ; Thu, 8 Dec 2005 12:44:53 -0500 (EST) Received: from UNKNOWN( ), claiming to be "[155.34.198.117]" via SMTP by llmail, id smtpdAAAOIaGuD; Thu Dec 8 12:44:32 2005 Message-ID: <439870FF.4080002@ll.mit.edu> Date: Thu, 08 Dec 2005 12:44:31 -0500 From: David Rysdam User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.11) Gecko/20050729 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pg >> Postgres General" Subject: date format Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/449 X-Sequence-Number: 88012 I could swear (but I don't think I can prove at this point) that 8.0 beta3 returned timestamps with milliseconds, like this: YYYY-MM-DD HH24:MI:SS.MS But 8.1 isn't doing that. I see functions to format the date, but that would require me to change all my existing SQL to specifically ask for the milliseconds. There's also the "set datestyle" thing, but the granularity doesn't exist to specify an exact format such as the above. Is there a way to tell postgres *exactly* what I want the *default* date output format to be?