posted 18 years ago
I hope combine the query as
select S.sched_time from schedule s,
(SELECT MAX(S.SCHED_START_DATE) START_TIME
FROM SCHEDULE S WHERE S.SCHED_START_DATE < SYSDATE
and id = 100 ) SS
where s.id = 100
and s.sched_time <= ss.start_date
and s.sched_time >= ss.start_date + ?
The direct query of below is working, but when I use setFloat(1, 1/2) is not working.
select S.sched_time from schedule s,
(SELECT MAX(S.SCHED_START_DATE) START_TIME
FROM SCHEDULE S WHERE S.SCHED_START_DATE < SYSDATE
and id = 100 ) SS
where s.id = 100
and s.sched_time <= ss.start_date
and s.sched_time >= ss.start_date + 1/2
Anyway to set value in this case?
Thanks,
[ August 10, 2005: Message edited by: Steve Jiang ]