Re: SQL query for events

[Williams, Tim]

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




        "<James> <healy>" <[EMAIL PROTECTED]>
        12/29/2000 09:34 AM
        Please respond to "ADSM: Dist Stor Manager"
<[EMAIL PROTECTED]>@SMTP@Exchange
        To:     [EMAIL PROTECTED]@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?