[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)



Siva,

I think we had to do something like this:

TO_CHAR(to_date('12/31/99','MM/DD/YY'),'MM/DD/YYYY')   !for Oracle
or
TO_CHAR(&temp_date, 'MM/DD/YYYY')                          !for SQR

HTH --- Y2K seems like so long ago!

Joe Johnson
PeopleSoft Systems Analyst
joejo@snellingcorp.com
972-776-1332

----- Original Message -----
From: "Siva Prasad Juluri" <jsiva@BANGALORE.IMRGLOBAL.COM>
To: <SQR-USERS@list.iex.net>
Sent: Friday, October 06, 2000 3:03 PM
Subject: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)


> hi friends,
>       I have a small problem, please can  u look into and help me out.
>
>       My goal is to take the current-date and printing on to the screen.
Before printing on to the screen i am moving the current to some other
temporary variable and 'Edit Mask'ing for purpose of showing year part as 4
digits(I mean showing the date as mm/dd/yyyy) Then I am getting
>
>   "SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)" warning
message.
>
> how to get rid of this message other than changing Standard settings in
SQR.INI file.
>
> Thanx,
> Siva
>
> _______________________________
> *** Confidentiality Notice ***
>
> Proprietary/Confidential
> Information belonging to IMRglobal Corp.
> may be contained in this message.
> If you are not a recipient indicated or
> intended in this message (or responsible
> for delivery of this message to such
> person), or you think for any reason that
> this message may have been addressed to
> you in error, you may not use or copy or
> deliver this message to anyone else.
> In such case, you should destroy this
> message and kindly notify the sender
> by reply email.
>