ADSM-L

sql select from "yesterday"

2000-08-16 09:21:43
Subject: sql select from "yesterday"
From: Winfried Heilmann <winfried.heilmann AT INFRACOR DOT DE>
Date: Wed, 16 Aug 2000 15:16:31 +0100
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
<Prev in Thread] Current Thread [Next in Thread>