Date Formats

[Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>]

Sorry to bother all non PeopleSoft users, but....

>From Day 1 here until yesterday, when I ran an SQR that inserted a date
into a table, I used the $AsOfToday string from the datetime SQC and life
was good.  But...today, when I run the exact same unmodified SQR's,
whether it be through SQRW or PS process scheduler, I get the following
error now and I am extremely baffled.

(SQR 5528) ORACLE OEXEC error -1830 in cursor 4:
   ORA-01830: date format picture ends before converting entire input
string

Error on line 222:
   (SQR 3735) Couldn't execute SQL.

As you can probably tell, we are using an Oracle Database with version
6 financials PS.

Can anybody help, we are practically 1 day from going live  and this had
to happen.  PLEASE HELP !!

Thank You

Mark Kraft
kraft@gunet.georetown.edu