strftime or date_format like function?

From: Zsolt Varga <redax(at)agria(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: strftime or date_format like function?
Date: 1999-05-30 22:18:00
Message-ID: Pine.LNX.4.10.9905310017220.5337-100000@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 Zalman Stern 1999-05-31 06:30:09 Re: [SQL] Column name's length
Previous Message Zsolt Varga 1999-05-30 22:14:41 Strftime or Date_format like function?