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 ---------------------------
"Williams, Tim" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/29/2000
11:38:32 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: SQL query for events
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?
