Re: %DateIn and %DateOut problem (?)

[Bob Buford <bbuford@CCCI.ORG>]

Tom,

In your TO_DATE function, the format (2nd parameter) is supposed to show the pattern that you are using in the first parameter
    e.g.   TO_DATE('11-NOV-98','DD-MON-YY')
              or
             TO_DATE('1998-11-11','YYYY-MM-DD').

The To_date function just makes your text data into the internal date format, which you don't have to be concerned with.

HTH

Bob

>>> "Nguyen, Tom P" <tom.p.nguyen@INTEL.COM> 11/12 2:41 PM >>>
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.