find last day of month

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: find last day of month
Date: 2005-12-08 22:54:01
Message-ID: dnadlk$13g7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table containing month column in format mm.yyyy

create table months ( tmkuu c(7));
insert into months values ('01.2005');
insert into months values ('02.2005');

How to create select statement which converts this column to date type
containing last day of month like

'2005-01-31'
'2005-02-28'

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmund 2005-12-08 23:19:33 Re: find last day of month
Previous Message Ed L. 2005-12-08 22:26:38 Re: is it possible to delete the psql log while psql is