Received: from mail.agria.hu (qmailr@agria.hu [194.196.126.2]) by hub.org (8.9.3/8.9.3) with SMTP id RAA93288 for ; Sun, 30 May 1999 17:53:58 -0400 (EDT) (envelope-from redax@mail.agria.hu) Received: (qmail 5049 invoked by uid 1000); 30 May 1999 21:51:29 -0000 Date: Sun, 30 May 1999 23:51:29 +0200 From: Zsolt Varga To: pgsql-sql@postgresql.org Subject: strftime or date_format like function? Message-ID: <19990530235129.A5009@lupus.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