use something along the lines of this
select * from adsm.actlog where
(cast((current_timestamp-date_time)day as decimal(18,0))=0)
> ----------
> From: Winfried Heilmann[SMTP:[EMAIL PROTECTED]]
> Reply To: ADSM: Dist Stor Manager
> Sent: Wednesday, August 16, 2000 9:16 AM
> To: [EMAIL PROTECTED]
> Subject: sql select from "yesterday"
>
> 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
>
