R: [GENERAL] find last day of month

>> "Andrus Moor" <[EMAIL PROTECTED]> writes: >> >>> I have a table containing month column in format mm. >>> >>> 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

Re: [GENERAL] find last day of month

On Fri, 2005-12-09 at 15:27 -0500, Chris Browne wrote: > "Andrus Moor" <[EMAIL PROTECTED]> writes: > > > I have a table containing month column in format mm. > > > > create table months ( tmkuu c(7)); > > insert into months values ('01.2005'); > > insert into months values ('02.2005'); > > > >

Re: [GENERAL] find last day of month

"Andrus Moor" <[EMAIL PROTECTED]> writes: > I have a table containing month column in format mm. > > 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

Re: [GENERAL] find last day of month

"Andrus Moor" <[EMAIL PROTECTED]> writes: > I have a table containing month column in format mm. > > 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

Re: [GENERAL] find last day of month

Andrus Moor wrote: I have a table containing month column in format mm. 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

[GENERAL] find last day of month

I have a table containing month column in format mm. 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-0