[no subject]

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   ------------- ------------- ---------
02/19/02   00:00:00 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

------=_NextPart_001_00CE_01C1BA2B.59B66410-- ------=_NextPart_000_00CD_01C1BA2B.59B1D030