Re: sql select from "yesterday"
2000-08-16 09:52:35
Subject: |
Re: sql select from "yesterday" |
From: |
"Cook, Dwight E" <cookde AT BP DOT COM> |
Date: |
Wed, 16 Aug 2000 08:52:12 -0500 |
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:winfried.heilmann AT INFRACOR DOT DE]
> Reply To: ADSM: Dist Stor Manager
> Sent: Wednesday, August 16, 2000 9:16 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
>
|
|
|