> -----Original Message-----
> From: Lance Prais [mailto:lprais_at_ts.checkpoint.com]
>
> I am trying to use the following insert statement but getting an
> error:"ORA-01843: not a valid month"
>
> What is the problem , I have converted the sysdate using this
> before with
> out any errors?
>
> insert into cp_license_use(Select A.Pc_session_id,
> a.pc_session_user_name,
> To_Char(SYSDATE,'MM/DD/YYYY HH:MI') From pt_client_event A where
> A.pc_event_op = 'LAUNCH' and A.pc_date >=SYSDATE -1
> minus
> Select B.Pc_session_id, b.pc_session_user_name,
> To_Char(SYSDATE,'MM/DD/YYYY
> HH:MI') From pt_client_event B where B.Pc_event_op = 'LOGOUT'
> and B.pc_date
> >=SYSDATE -1);
Just a wild guess, but what is the datatype for field pt_client_event.pc_date ? If it has varchar2 for example, and Oracle has to do an implicit conversion to a date for the comparison to sysdate, then you might get error ORA-01843.
Received on Mon Jan 28 2002 - 14:16:44 CST
