find last day of month - Mailing list pgsql-general

From Andrus Moor
Subject find last day of month
Date
Msg-id dnadlk$13g7$1@news.hub.org
Whole thread Raw
Responses Re: find last day of month
List 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.



pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: is it possible to delete the psql log while psql is
Next
From: Jeffrey Melloy
Date:
Subject: Re: find last day of month