I think problem is not in query format:
"select  *  from events" only information for current day.
In addition, most possible "q events" takes data from table SUMMARY, not from 
EVENTS.
By the way, I am not sure I am right.

________________________________________
From: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Guenther Bergmann [guenther_bergmann AT GBERGMANN DOT DE]
Sent: Friday, March 26, 2010 8:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] query node vs select * from nodes

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

Please consider the environment before printing this Email.

"This email message and any attachments transmitted with it may contain 
confidential and proprietary information, intended only for the named 
recipient(s). If you have received this message in error, or if you are not the 
named recipient(s), please delete this email after notifying the sender 
immediately. BKME cannot guarantee the integrity of this communication and 
accepts no liability for any damage caused by this email or its attachments due 
to viruses, any other defects, interception or unauthorized modification. The 
information, views, opinions and comments of this message are those of the 
individual and not necessarily endorsed by BKME."