Answering from the (Oracle) SQL standpoint, not necessarily from the
ADSM standpoint...
A Date object usually contains a date and a time. If you want something
specific to a date, you need to remove the time component. If I want
rows from yesterday or before, for instance, I could "select ... where
date_field < trunc(sysdate)" as one example. If I only want yesterday,
then I could say "select ... where trunc(date_field) = trunc(sysdate) -
1".
Someone else will need to respond with the ADSM relative issues.
Alex Sokolek
Winfried Heilmann wrote:
>
> Hi,
>
> for reporting I work with sql select.
>
> Can anybody tell me, how I can do a select from a table (for example
> actlog) only with the record from yesterday or the day before yesterday?
>
> I can select the records from today with
>
> select ..................................where date(date_time)=current
> date .
>
> regards winfried
