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-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 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'); How to create

R: [GENERAL] find last day of month

2005-12-09 Thread Luciano Bastianello
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

[GENERAL] find last day of month

2005-12-08 Thread Andrus Moor
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'

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