Adsm Group

In a previous Email from Jim Healy to the group,  it was suggested to use
the following WHERE statement: to get the prior day events.

Try adding
        where days(current_timestamp)-days(date_time)<1
        to your select statement...

The varibles DAYS, CURRENT_TIMESTAMP, & DATE_TIME are not part of the
EVENTS table is there another table that has to be JOINED to the events
table
to get the above variables.

I am using the Microsoft Excel ODBC query to get the event information.


Thanks

Joe Marchesani


t---------------------- Forwarded by Joseph M Marchesani/NYM/Equitable on
01/03/2001 03:13 PM ---------------------------

James J Healy
12/29/2000 11:50 AM


To:   Joseph M Marchesani/NYM/Equitable@AXA-Equitable
cc:

Subject:  Re: SQL query for events


---------------------- Forwarded by James J Healy/NYM/Equitable on
12/29/2000 11:49 AM ---------------------------
12/29/2000 11:49 AM ---------------------------


"Williams, Tim" <Tim.Williams AT FRITOLAY DOT COM>@VM.MARIST.EDU> on 12/29/2000
11:38:32 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  Re: SQL query for events


        try adding
        where days(current_timestamp)-days(date_time)<1
        to your select statement...




        "<James> <healy>" <James.Healy2 AT AXACS DOT COM>
        12/29/2000 09:34 AM
        Please respond to "ADSM: Dist Stor Manager"
<ADSM-L AT VM.MARIST DOT EDU>@SMTP@Exchange
        To:     ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
        cc:

        Subject:        SQL query for events

        Can anyone help with the sql query I could use to see events that
occurred
        form yesterday to today?