SQL Date Format

From: <bcrowell_at_sbmct.com>
Date: Fri, 12 Feb 1999 19:53:30 GMT
Message-ID: <7a20rl$nvj$1@nnrp1.dejanews.com>

I am trying to retreive data from my oracle database , based on a time. For example the following code will retreive the data if it is 11:00 or later. What i am trying to do is if i have some data that i know happend at 11:13am and i did NOT want my seql to pick it up , How would i format this ??

Thanks for the help
Bruce

CONNECT INTERNAL/password_at_orapcbk;

Select queapplhist.returncd, queapplhist.applnbr, queapplhist.checkpoint, queapplhist.startdatetime
from queapplhist
where queapplhist.returncd <> '0'

and queapplhist.startdatetime > (to_date(sysdate)+11/24);

EXIT; -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 12 1999 - 13:53:30 CST