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@VM.MARIST.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
