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 22:14:41
Message-ID: 19990531001441.A5278@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:18:00 strftime or date_format like function?
Previous Message Zsolt Varga 1999-05-30 21:51:29 strftime or date_format like function?