X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A31DDD1C510 for ; Fri, 15 Aug 2003 11:30:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 20212-10 for ; Fri, 15 Aug 2003 08:30:03 -0300 (ADT) Received: from web11505.mail.yahoo.com (web11505.mail.yahoo.com [216.136.172.37]) by svr1.postgresql.org (Postfix) with SMTP id 83C5FD1C4D6 for ; Fri, 15 Aug 2003 08:29:59 -0300 (ADT) Message-ID: <20030815113002.69121.qmail@web11505.mail.yahoo.com> Received: from [152.21.2.35] by web11505.mail.yahoo.com via HTTP; Fri, 15 Aug 2003 04:30:02 PDT Date: Fri, 15 Aug 2003 04:30:02 -0700 (PDT) From: Dawn Albrecht Subject: New and Timestamp Question To: pgsql-chat@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/3 X-Sequence-Number: 4 Greets, I am new to postgres and I'm not even sure if I'm writing to the correct place but here it goes: All I want to do is change the timestamp format. I can change the 'date' part of it, but the time is always delivered as: 14:00:00 instead of 2:00:00 PM. I do not wish to view army time, but regular non-military time. I used the Set datestyle command and no matter what I set it to, the date itself changes, but not the time format? Any suggestions? I will be using the timestamp field on an ASP and JSP page and I was hoping to just modify its view in the database itself. Thank you, DA __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com