[Date Prev][Date Next][Thread Prev][Thread Next]
[SQRUG Home Page]
Re: SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000)
I think we had to do something like this:
TO_CHAR(to_date('12/31/99','MM/DD/YY'),'MM/DD/YYYY') !for Oracle
TO_CHAR(&temp_date, 'MM/DD/YYYY') !for SQR
HTH --- Y2K seems like so long ago!
PeopleSoft Systems Analyst
----- Original Message -----
From: "Siva Prasad Juluri" <jsiva@BANGALORE.IMRGLOBAL.COM>
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
> how to get rid of this message other than changing Standard settings in
> *** Confidentiality Notice ***
> 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.