select schedule_name, status, result, reason -
from events -
where date(scheduled_start) <= current_date - cast(1 as interval day)

Zlatko Krastev
IT Consultant




Please respond to <r.harderwijk AT factotum DOT nl>
To:     "'Zlatko Krastev/ACIT'" <acit AT attglobal DOT net>
cc:

Subject:        RE: Select statement (using events table)

Hi Zlatko,

So that's the trick...

I've trying to get the startdate set, using some example statements, but I
cannot get it done it seems. Here's what I tried:

select schedule_name,status,result,reason from events where
(scheduled_start - 1 day)

Well, that doesn't work :-( (obviously because the syntax isn't right :-)
).
Do you happen to know how that works?

Kind regards,

Rick