X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3DF8BD1B4EF for ; Wed, 22 Oct 2003 11:41:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94358-01 for ; Wed, 22 Oct 2003 08:40:32 -0300 (ADT) Received: from web41009.mail.yahoo.com (web41009.mail.yahoo.com [66.218.93.8]) by svr1.postgresql.org (Postfix) with SMTP id E69B6D1B4E3 for ; Wed, 22 Oct 2003 08:40:28 -0300 (ADT) Message-ID: <20031022114032.44723.qmail@web41009.mail.yahoo.com> Received: from [66.108.25.20] by web41009.mail.yahoo.com via HTTP; Wed, 22 Oct 2003 04:40:32 PDT Date: Wed, 22 Oct 2003 04:40:32 -0700 (PDT) From: Theodore Petrosky Subject: Re: Timestamp To: Abdul Wahab Dahalan , pgsql-sql@postgresql.org In-Reply-To: <3F963983.2020505@mimos.my> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/285 X-Sequence-Number: 15685 Check this out.... http://www.postgresql.org/docs/7.3/static/functions-formatting.html to_char(departure, 'MM-DD-YYYY HH24:MI:SS') as newformatdeparture Ted --- Abdul Wahab Dahalan wrote: > Hi ! > In my database I've a field "departure" with > timestamp without time zone > data type. > eg : > departure > 2003-11-01 14:29:46 > > Now I want to select it as in this format 01-11-2003 > 14:29:46 How should > I do it?. > > Thank you for any help. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com