Received: from student.cs.ucc.ie (student.cs.ucc.ie [143.239.211.125]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2NKUUw61969 for ; Fri, 23 Mar 2001 15:30:30 -0500 (EST) (envelope-from fullam@student.cs.ucc.ie) Received: (from fullam@localhost) by student.cs.ucc.ie (8.9.3/8.9.3) id UAA27942 for pgsql-php@postgresql.org; Fri, 23 Mar 2001 20:30:27 GMT From: Naomi Fullam Message-Id: <200103232030.UAA27942@student.cs.ucc.ie> Subject: format date retrieved from database To: pgsql-php@postgresql.org Date: Fri, 23 Mar 2001 20:30:27 +0000 (GMT) X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/50 X-Sequence-Number: 235 Hi I found this function for mysql SELECT DATE_FORMAT(myDateField, '%d-%m-%Y') FROM myTable The DATE_FORMAT function allows one to format myDateField as I see fit, I want to have it in date-month-year format. myDateField is of type date. Basically I was just wondering if there is a similar Postgres command? Thanks in advance! Naomi