ADSM-L

sql select from "yesterday"

2015-10-04 17:28:41
Subject: sql select from "yesterday"
From: Winfried Heilmann [SMTP:winfried.heilmann AT INFRACOR DOT DE]
To: ADSM-L AT VM.MARIST DOT EDU
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>