strftime or date_format like function?

From: Zsolt Varga <redax(at)mail(dot)agria(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: strftime or date_format like function?
Date: 1999-05-30 21:51:29
Message-ID: 19990530235129.A5009@lupus.agria.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Zsolt Varga 1999-05-30 22:14:41 Strftime or Date_format like function?
Previous Message John J. Boris, Sr. 1999-05-30 15:31:29 Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY?