Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+statement\s+\?\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+statement\s+\?\s*$/: 2 ]

Total 2 documents matching your query.

1. select statement ? (score: 1): Author: Andreas Rensch <RenschA AT ALTE-LEIPZIGER DOT DE>; Date: Fri, 1 Dec 2000 15:43:16 +0100; Hi, how can i code a select statement, which gives me all nodename related events from the actlog and the last hour? The "current-time-1" is not the right statement. select servername,nodename,date_t; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-12/msg00017.html (10,741 bytes)
2. Re: select statement ? (score: 1): Author: Hermann Frasch <frasch AT RUS.UNI-STUTTGART DOT DE>; Date: Fri, 1 Dec 2000 16:03:32 +0100; Hi Andreas, try the following statement: select servername,nodename,date_time from actlog where (cast((current_timestamp-date_time)hours as integer)>1) Hope it works. Regards Hermann Frasch Andreas R; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-12/msg00020.html (11,752 bytes)

Current List: 1 - 2
Page: [1]