[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

%DateIn and %DateOut problem (?)



All,
This happened to us and we still don't know what went wrong in our
development environment.
Under Recruit Work Force - Use - Application Data - Application Data1

When I tried to change Application Status from Active to Hired of any
employee,
I got this message first:

SQL error. Stmt #: 0  Error Position: 50  Return: 1858 - ORA-01858: a
non-numeric character was found where a numeric was expected

And then:

Update ps_job_requisition set status_dt = TO_DATE('11-NOV-98','YYYY-MM-DD'),
close_dt = TO_DATE('11-NOV-98','YYYY-MM-DD'),job_req_status = 'F' where
job_requisition# = '110638'

Why Peoplesoft code passed %Datein as '11-NOV-98'  which is contrast to the
format 'YYYY-MM-DD'?

Does anyone have any idea?

Thanks in advance!

Tom Nguyen
Intel Co.