[ADSM-L] query node vs select * from nodes

ADSM-L

[Top] [All Lists]

[ADSM-L] query node vs select * from nodes

2010-03-26 13:23:36

Subject:	[ADSM-L] query node vs select * from nodes
From:	Guenther Bergmann <guenther_bergmann AT GBERGMANN DOT DE>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Fri, 26 Mar 2010 18:22:13 +0100

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

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
*[ADSM-L] query node vs select from nodes*, Guenther Bergmann* <= *Re: [ADSM-L] query node vs select from nodes*, Richard Sims* *Re: [ADSM-L] query node vs select from nodes*, Grigori Solonovitch* *Re: [ADSM-L] query node vs select from nodes*, David McClelland*

Previous by Date:	Re: [ADSM-L] Query for inactive data summary, Haberstroh, Debbie (IT)
Next by Date:	*Re: [ADSM-L] query node vs select from nodes*, David McClelland*
Previous by Thread:	[ADSM-L] Query for inactive data summary, Haberstroh, Debbie (IT)
Next by Thread:	*Re: [ADSM-L] query node vs select from nodes*, Richard Sims*
Indexes:	[Date] [Thread] [Top] [All Lists]