Search the list archive for select+event. http://search.adsm.org/
In particular check out http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html -----Original Message----- From: Jane Bamberger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 3:26 PM To: [EMAIL PROTECTED] Subject: select staetment Hi, Hopefully someone can help me. I want to do a select statement on the events table, but for some reason when I do a select - it will only give me todays events. If I do a query with a begind of yesterday - I get yesterday's events. for example: tsm: BASSETT>select * from events where date(actual_start)='02/19/2002' ANR2034E SELECT: No match found using this criteria Whereas I can do a q event * * begind='02/19/2002' as see this: tsm: BASSETT>q event * * begind='02/19/2002' Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 02/19/02 00:00:00 02/19/02 00:02:57 GW1-INCR GW1 Completed 02/19/02 01:00:00 02/19/02 01:15:15 TSI-INCR TSI Completed 02/19/02 01:00:00 02/19/02 01:01:01 BASSETT01_IN- BASSETT01 Completed CR 02/19/02 01:00:00 02/19/02 01:00:10 TESTAPP-INCR TESTAPP Completed 02/19/02 01:00:00 02/19/02 01:15:17 TRANSDB-INCR TRANSDB Completed 02/19/02 01:46:50 02/19/02 01:56:46 GISERVER_INCR GISERVER Completed 02/19/02 02:00:00 02/19/02 02:08:17 TRANSIF_INCR TRANSIF Completed 02/19/02 02:00:00 02/19/02 02:06:27 STATGW-INCR STATGW Completed 02/19/02 03:00:00 02/19/02 03:07:11 UTILSRVR-INCR UTILSRVR Completed 02/19/02 03:00:00 02/19/02 03:01:25 TSTTRANSDB-I- TSTTRANSDB Completed NCR 02/19/02 03:20:00 02/19/02 03:21:58 MAILHUB-INCR MAILHUB Completed 02/19/02 04:00:00 02/19/02 04:03:11 ORSRVR-INCR ORSRVR Completed 02/19/02 04:00:00 02/19/02 04:13:54 BH1-INCR BH1 Completed 02/19/02 04:00:00 02/19/02 04:12:21 TSTTRANSIF-I- TSTTRANSIF Completed NCR 02/19/02 05:00:08 02/19/02 05:05:15 CWS01-INCR CWS01 Completed 02/19/02 09:20:00 02/19/02 09:21:30 MAILHUB-INCR MAILHUB Failed Any suggestions? I want to use select to do more processing - else I have to parse files.. not a problem - but a select would be easier. Jane %%%%%%%%%%%%%%%%%%%%%%%%%%%% Jane Bamberger IS Department Bassett Healthcare 607-547-4784