Re: elsif statement

From: Tome Gulevski <volvia.tome_at_memo.volvo.se>
Date: 1998/01/21
Message-ID: <34C61814.4541@memo.volvo.se>#1/1

Laura Bellini wrote:
>
> In phonetic Oracle form, I am trying to do the following:
>
> ELSIF (SELECT TO_CHAR(NEW_START_DATE, 'HH:MI') > '09:00') THEN
>
> etc...
>
> Check to see if the hour in the New_start_date variable is > 9:00 am.
>
> How to??
>
> thanks!
>
> Laura Bellini
> laura_bellini_at_compaq.com

Try this:

ELSIF TO_NUMBER(TO_CHAR(w_new_start_date, 'HH24MI')) > 0900 THEN ....

/T Gulevski Received on Wed Jan 21 1998 - 00:00:00 CST