pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedstrftime or date_format like function?
3+ messages / 2 participants
[nested] [flat]
* strftime or date_format like function?
@ 1999-05-30 21:51 Zsolt Varga <redax@mail.agria.hu>
0 siblings, 0 replies; 3+ messages in thread
From: Zsolt Varga @ 1999-05-30 21:51 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Strftime or Date_format like function?
@ 1999-05-30 22:14 Zsolt Varga <redax@mail.agria.hu>
0 siblings, 0 replies; 3+ messages in thread
From: Zsolt Varga @ 1999-05-30 22:14 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* strftime or date_format like function?
@ 1999-05-30 22:18 Zsolt Varga <redax@agria.hu>
0 siblings, 0 replies; 3+ messages in thread
From: Zsolt Varga @ 1999-05-30 22:18 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-05-30 22:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-30 21:51 strftime or date_format like function? Zsolt Varga <redax@mail.agria.hu>
1999-05-30 22:14 Strftime or Date_format like function? Zsolt Varga <redax@mail.agria.hu>
1999-05-30 22:18 strftime or date_format like function? Zsolt Varga <redax@agria.hu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox