X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 128FF9DC84A for ; Fri, 10 Feb 2006 02:18:13 -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 50804-03 for ; Fri, 10 Feb 2006 02:18:11 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1FB509DC818 for ; Fri, 10 Feb 2006 02:18:10 -0400 (AST) Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by svr4.postgresql.org (Postfix) with ESMTP id C78F35AF03D for ; Fri, 10 Feb 2006 06:18:10 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=talk.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1F7Rbd-0002dU-Iu for pgsql-sql@postgresql.org; Thu, 09 Feb 2006 22:18:09 -0800 Message-ID: <2865031.post@talk.nabble.com> Date: Thu, 9 Feb 2006 22:18:09 -0800 (PST) From: "superboy143 (sent by Nabble.com)" Reply-To: superboy143 To: pgsql-sql@postgresql.org Subject: date MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-Sender: lists@nabble.com X-Nabble-From: superboy143 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.217 required=5 tests=[AWL=0.217] X-Spam-Score: 0.217 X-Spam-Level: X-Archive-Number: 200602/111 X-Sequence-Number: 24121 Hello, How can I write an sql query in postgresql so that I can insert a date into a table in the format DD-MM-YYYY, and when I select the date from the table I should get the date in the same format. -- View this message in context: http://www.nabble.com/date-t1097526.html#a2865031 Sent from the PostgreSQL - sql forum at Nabble.com.