For a more intuitive treatment,
Oracle 8.1.6 has introduced a proper CASE statement.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Ulrik Hoffmann wrote in message <8g8aec$qf05$1_at_fu-berlin.de>...
>Hi, what about
>
>
>SELECT minutes,
>TO_CHAR(FLOOR((minutes-1)/15)*15+1)||'-'||TO_CHAR(FLOOR((minutes-1)/15
>)*15+15) band
>FROM minutes_table
>
>Hth,
>Uli
>
>> 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 Tue Jun 06 2000 - 00:00:00 CDT
