Received: from mail.agria.hu (qmailr@agria.hu [194.196.126.2]) by hub.org (8.9.3/8.9.3) with SMTP id SAA95206 for ; Sun, 30 May 1999 18:16:56 -0400 (EDT) (envelope-from redax@mail.agria.hu) Received: (qmail 5284 invoked by uid 1000); 30 May 1999 22:14:41 -0000 Date: Mon, 31 May 1999 00:14:41 +0200 From: Zsolt Varga To: pgsql-sql@postgresql.org Subject: Strftime or Date_format like function? Message-ID: <19990531001441.A5278@agria.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i hi! I wonder, but is it possible to make a format like this: '1999.02' from the date '1999-02-01' in mysql: select date_format('Y.m', date_field) from table; so basicly I'm looking for a strftime() like function thanks, redax