You can use 'decode' en 'sign' to compare sysdate and trunc(sysdate)+20hours
(i dont know the exact syntax): if sign is negatif then take the day before
else today.
Iam not in the position to spell it out exactly but iam sure it is possibly.
Gr Johan
Don A. <DBA_at_direct.ca> schreef in berichtnieuws
ie8a4vgrucuoa8babcs8jrkqqc9177t8vk_at_4ax.com...
> Greetings,
>
> I'm trying to select records from a table based on a date field and can't
seem
> to figure out how to set up variable date checking. This select statement
is in
> a view so it needs to be able to determine the current time and then
request
> either today's data or yesterday's. (All of this is on 8.1.7.2.5 under
W2K)
>
> Basically I want all records between a certain time (say 6 PM and 10 PM)
from
> the nearest current time.
>
> That is, if it's currently before 10 PM I want the data from last night,
> otherwise grab the data from tonight.
>
> I can put in a set date and time manually :
>
> i.e. ... where RDATE between ('08-FEB-03 18:00:00','DD-MM-YY hh24:mi:ss')
> and ('08-FEB-03 22:00:00','DD-MM-YY hh24:mi:ss')
>
> But obviously it means the select statement is static. How can I check the
> current time and then pass this to the where clause so it requests the
> appropriate days data?
>
> Any help, pointers, suggestions appreciated.
>
> Thanks,
>
> Don
Received on Sat Feb 08 2003 - 11:46:42 CST
