Re: sql select from "yesterday"

[Gary Ison]

Winfried,

        You can qualify the date search using the DATE(timestamp) function.
For example,

                Select ........ where date(date_time)='mm/dd/ccyy'

for the date portion of the timestamp value in the activity log table
(actlog).  You could parameterize the search value using the ('$1')
replacement form (instead of specifying the actual date) to create a
re-usable script.

        Gary L. Ison
        Governor's Office for Technology
        101 Cold Harbor Drive
        Frankfort, Ky.   40601
        Phone:  (502) 564-8724
            Fax:  (502) 564-6856
E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

-----Original Message-----
From:   Winfried Heilmann [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 16, 2000 10:17 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