not a vaild month error [message #37271] |
Mon, 28 January 2002 09:52 |
Lance Pris
Messages: 40 Registered: January 2002
|
Member |
|
|
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?
Thank you in advance
Lance
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);
|
|
|
|
|