Postgres Pro
Downloads
Home   >   mailing lists

strftime or date_format like function? - Mailing list pgsql-sql

From Zsolt Varga
Subject strftime or date_format like function?
Date
Msg-id 19990530235129.A5009@lupus.agria.hu
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "John J. Boris, Sr."
Date:
Subject: Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY?
Next
From: Zsolt Varga
Date:
Subject: Strftime or Date_format like function?