pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
strftime 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