Re: SQR 4.3.2 date problem

[Allen Wong <awong01@YAHOO.COM>]

Les,

The "alter session set nls_date_format = 'DD-MON-YYYY' is needed if
you are inserting or comparing dates because the default date format
for Oracle is 'DD-MON-YY'.  My co worker was having insert problems
with her conversion sqr after the sqr_db_date_format was set, so I
added the alter session and everything worked.

I am just pissed off by the fact that PeopleSoft did not include this
info.  I called their tech support on the problem and they insist on
tweaking their sqcs.  I have told them repeatedly about the problem,
they don't understand.


---Les Hancock <les_hanc@YAHOO.COM> wrote:
>
> In doing more tests, the -zif parameter doesn't appear to be
> necessary, if the following is in your c:\windows\sqr.ini or
> c:\winnt\sqr.ini:
>
> [Environment:Oracle]
> SQR_DB_DATE_FORMAT=DD-MON-YYYY
>
> And, you do not really need the SQL statement:  alter session set
> nls_date_format = 'DD-MON-YY'
>
> Of course, the -zif parameter doesn't hurt (Peoplesoft seems to want
> it present) and may be needed for other reasons.  Ditto for the SQL
> alter session statment.
>
> So, this simple program returns a 4 digit date with the
> SQR_DB_DATE_FORMAT=DD-MON-YYYY in the sqr.ini:
>
>
> !-----*
>
> !-----*
> Begin-Report
> !-----*
> do Main-Select
>
> End-Report
>
>
> !-----*
> begin-procedure main-select
> !-----*
> begin-SELECT
> SYSDATE           &curr_date
> FROM dual
> end-SELECT
>
> display &curr_date
>
> end-procedure main-select
>
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com