Re: Date Formats

[Aya Fall <afall@NS.SYMPATICO.CA>]

Mark Kraft wrote:
Hi Mark:

Move $AsOfNow to $AsOfDate, or sysdate if you're using this in a where
clause.
HTH.

Aya


> 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