SQL query events
2001-01-05 09:53:42
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?
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL query events,
Joseph Marchesani <=
|
|
|