Re: Date Formats

["Mosley, Banessa" <Banessa_Mosley@MAIL.CI.BALTIMORE.MD.US>]

Mark,

Is your date in the YYYY-MM-DD format (which I believe is the standard
date format for Oracle) ?  I have gotten this error before and
converting my dates to this format seemed to help.  If you are trying to
insert data into a table, try putting the to_date function in your
insert statement.

example

begin-SQL
INSERT into PS_TEST_TBL (
DATE_COL,
COL1,
COL2)
VALUES
(TO_DATE($DATE_VAR,'YYYY-MM-DD'),
$COL1,
$COL2)
end-SQL

I hope this helps !!!

Banessa Mosley
Business Information Technology

> -----Original Message-----
> From: Mark Kraft [SMTP:kraftm@GUNET.GEORGETOWN.EDU]
> Sent: Wednesday, July 22, 1998 11:34 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Date Formats
>
> 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