SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Checking if current time is less than a particular time

2980109Jul 12 2016 — edited Jul 12 2016

select to_char(sysdate,'dd-mon-rr hh24:mi:ss')st from dual;

12-jul-16 09:24:51

Im my form,I have written the below code:

select to_char(sysdate,'dd-mon-rr hh24:mi:ss')st from dual;

if (st<=sysdate||' 11:00:00')

then

:text_item42:='yes';

else

:text_item42:='no';

end if;

But this goes to the else part and the text item shows 'no'.09:24:51 is obviously less than '11:00:00'.

Pls help on this.

This post has been answered by Manik on Jul 12 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2016

Added on Jul 12 2016

4 comments

2,282 views