Re: Need help Datefield Retrieval like this mmddyyyy

[David Dawes Stanley <stanledd@SNYONEVA.CC.ONEONTA.EDU>]

I agree,
        But I do not work with peoplesoft. We prepare rule based software to over a
dozen campuses. Other than the software we receive form our vendor, we make
modifications and also write sotware in SQR to provide enhancements to the
product.
        Dealing with severaul campuses, each of which are at different levels of
VMS, Oracle and the SOFTWARE product we deliver(BANNER), it sometimes works
to the best to be able to manipulate the NLS_DATE_FORMAT for the session.
        In cases in which the campuses have different NLS_DATE_FORMATS, We found it
easier to force SQR to use a specified date FORMAT.
        This may not always work for some shops, but in some cases it might be ok.
Anyway, I posted as another solution as to provide alternative solutions.

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Steven E. Davies
> Sent: Thursday, September 24, 1998 8:51 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Re: Need help Datefield Retrieval like this mmddyyyy
>
>
> Do NOT do this if you are using PeopleSoft unless you are prepared to
> modifiy delivered SQRs. PeopleSoft SQRs uses default native date
> formats throughout. Changing the default will cause those to stop
> working unless they are modified.
>
> In my opinion, this is not a good decision for PeopleSoft. In other
> environments, it may be just fine.
>
> Steve
>
> ---David Dawes Stanley <stanledd@SNYONEVA.CC.ONEONTA.EDU> wrote:
> >
> > Another Solution, maybe not always the best, but a different twist
> on date
> > formatiing (For Oracle Databases). This works fine if you want all
> your
> > dates in this format for the session, but do not want to alter the
> date
> > format for the database. Heres the code...
> >
> > BEGIN-SETUP
> > BEGIN-SQL
> > ALTER SESSION SET NLS_DATE_FORMAT='MMDDYYYY'
> > END-SQL
> > END-SETUP
> >
> > BEGIN-PROGRAM
> >   do MAIN
> > END-PROGRAM
> >
> > BEGIN-PROCEDURE MAIN
> > BEGIN-SELECT
> > TABLE_DATE_FIELD &date
> > FROM TABLE_NAME
> > WHERE CONDITIONS = CONDITIONS
> > END-SELECT
> > END-PROCEDURE MAIN
> >
>
> ==
>
>
> Steven E. Davies
> ------------------------------
> "Quid quid latine dictum sit,
>  altum viditur."
> ------------------------------
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>