Re: %DateIn and %DateOut problem (?)

["Ranade, Sameer" <sranade@BRISHOSP.CHIME.ORG>]

Hi,

        You should look at your ORACLE default date format you are
using. I think you have NLS_DATE_FORMAT set to 'DD-MON-YYYY'.
In that case you may have to change your SQL update.
        Good luck,

-Sameer

-----Original Message-----
From: Nguyen, Tom P [mailto:tom.p.nguyen@INTEL.COM]
Sent: Thursday, November 12, 1998 2:41 PM
To: Multiple recipients of list SQR-USERS
Subject: %DateIn and %DateOut problem (?)
Importance: High


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.