Re: Date

[Atul Shrivastava <atulindia@YAHOO.COM>]

Check your setenv.sqc on the server. In the 'Standard
ORACLE parameters' check '#define Year4'. The value
might be '0'.Change it '1' to ensure that the years
are printed as 'YYYY'.

PeopleSoft delivers an SQC called setupdb.sqc. It
includes an alter session command. This is where the
date format is set for the SQR. It seems you have a
different versions on the client and Unix.

In most SQRs, the setupdb.sqc is not directly included
in the SQR. It is usually included in another
setup??.sqc.

Your NLS_LANG parameter could be wrong too. The key to
solving that problem was in the workstation's NLS_LANG
setting for the registry. Changing it from
AMERICAN_AMERICA.WE8ISO8859P1 (western European
character set) to AMERICAN_AMERICA.US7ASCII (American
character set) would do the trick. whichever you use,
that the server should match the client.

HTH
--- "Brickl, Maria" <mbrickl@UWC.EDU> wrote:
> I have this program where I have it look at a
> flatfile (dept_line.csv) and
> insert those values into a table. The date in my
> table was 1-JUL-01 but when
> I query the data that was just loaded it has as the
> date - 7/1/0001. I want
> it to be 2001. Any ideas why this may have happened?
>
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
> Maria K Brickl
> Information Systems Programmer/Analyst
> University of Wisconsin Colleges
> 780 Regent St, PO Box 8680, Madison, WI  53708-8680
> Phone: 608.265.2677 / Fax: 608.265.5770
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*


__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/