Hi, I tried this. not work well when in_value < 60:
SELECT TO_CHAR( CASE WHEN 30 < 60 THEN 30 ELSE 30/60
END , '9.99') FROM DUAL;
it returns:
TO_CH
-----
#####
any idea why?
Thanks
--- Jan Pruner <[EMAIL PROTECTED]> wrote:
> Don't use DECODE, but CASE
>
> SELECT TO_CHAR(
> CASE WHEN in_value < 60 THEN in_value ELSE
> in_value/60 END
> , '9.99'
> ) FROM DUAL;
>
> JP
>
>
> > ____________________Reply
> Separator____________________
> > Author: Yexley Robert D Contr Det 1 AFRL/WSI
> <[EMAIL PROTECTED]>
> > Date: 5/20/2002 7:08 AM
> >
> > I was wondering if anyone might have tried this
> before, because I can't
> > seem to get it to work. I'd like to be able to
> determine which unit of
> > measure to concatenate to a value by using a
> decode statement in the query.
> > I have a column in the database that stores time
> in minutes, and I'd like
> > to be able to show the output in minutes if the
> value is less than 60, but
> > in hours (such as 3.27 hours) if the value is
> greater than 60. So far I've
> > tried the following statement, but it seems to be
> blowing up on the first
> > comparison operator:
> >
> > SELECT decode(in_value,
> to_char(to_number(in_value) <= to_number('60')),
> > to_char(in_value)||' minutes',
> to_char(to_number(in_value) >
> > to_number('60')), to_char(in_value/60, '9.99')||'
> hours')
> > FROM dual
> > /
> >
> > I'm selecting from dual just until I can get the
> query working at all. Is
> > what I'm trying to do even possible? Any help or
> ideas would be greatly
> > appreciated. Thanks in advance.
> >
> > _YEX_
> >
> > /*
> >
> > || Robert D. Yexley
> > || Oracle Programmer/Analyst
> > || Easylink Services Corporation
> > || Professional Services
> > || Contractor - Wright Research Site MIS
> > || Det-1 AFRL/WSI Bldg. 45 Rm. 062
> > || (937) 255-1984
> > || [EMAIL PROTECTED]
> > || <)))><
> >
> > */
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jan Pruner
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Joshua
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
