Re: [GENERAL] find last day of month

2005-12-09 Thread Sven Willenberger
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

2005-12-09 Thread Chris Browne
"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

2005-12-09 Thread Edmund
"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

2005-12-08 Thread Jeffrey Melloy
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