Fraustratingly, you'll need to use an absolute date (rather than relative date 
as below) when selecting from the events table. 

/David Mc

------Original Message------
From: Guenther Bergmann
Sender: ADSM: Dist Stor Manager
To: ADSM-L AT VM.MARIST DOT EDU
ReplyTo: ADSM: Dist Stor Manager
Subject: [ADSM-L] query node vs select * from nodes
Sent: 26 Mar 2010 17:22

Hi TSMers,

If i do:
q event * *  begind=today-1
i get a lot of output for events that happened yesterday.

If i issue:
select * from events where days(current_timestamp)-days(scheduled_start)>1

i get no results. Can someone explain the difference? What does q event do 
other than selecting information from the events table?

Thanks in advance

regards Günther

-- 
Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany
Guenther_Bergmann at gbergmann dot de


Sent from my BlackBerry® wireless device