Re: elsif statement

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/01/20
Message-ID: <34c529e6.2479645@192.86.155.100>#1/1

elsif ( to_char( new_start_date, 'HH24:MI' ) > '09:00' ) then   ...
end if;

forget the select. don't forget the HH24 not just HH format (so 8pm will be 20 not 08..)

On Tue, 20 Jan 1998 21:34:09 GMT, "Laura Bellini" <laura.bellini_at_compaq.com]> 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
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jan 20 1998 - 00:00:00 CST