Re: bands - sql statement

Hi,
try using a stored function like

create or replace function fct_konv(v_minute IN number) return varchar2 as begin

   if v_minute < 16 then

      return '1-15';
   elsif v_minute < 31 then

      return '16-30';
   elsif v_minute < 46 then

      return '31-45';
   else

      return 'upper limit';
   end if;
exception

   when others then

      return 'error';
end;
/

create table tbl_min (minute number(4));

insert into tbl_min values (1);
insert into tbl_min values (16);
insert into tbl_min values (90);

select fct_konv(minute) from tbl_min;
FCT_KONV(MINUTE)

Hth

Klaus
Cobra__77 <Cobra__77_at_hotmail.com> schrieb in im Newsbeitrag: 4LNV4.1955$sW4.12850_at_news-server.bigpond.net.au...
[Quoted] > I have a field in a table that has time in minutes as integer...eg 1 , 2,
 3
> no upper limit...and I want to convert this into 15 minutes bands...eg 1
 to
> 1-15 , 2 to 1-15 ....and 16 to 16-30 ... 17 to 16-30..... etc etc
> so my bands are 1-15 , 16-30, 31-45 ..... no upper limit ...any way to do
> this conversion in sql?
>
>
>
>
>
>
Received on Mon May 22 2000 - 00:00:00 CEST