Home » Developer & Programmer » Reports & Discoverer » very urgent .....year 1999 recods appearing as 2099 in my reports...
very urgent .....year 1999 recods appearing as 2099 in my reports... [message #88125] Wed, 27 March 2002 23:19 Go to next message
Gurusubramanyam
Messages: 79
Registered: July 2001
Member
very urgent .....year 1999 recods appearing as 2099 in my reports...how to format the to show the actual century of the date? anybody knows help me..
its very urgent..

Advanced thanks for solutions,

prasad

Report message to a moderator

Re: very urgent .....year 1999 recods appearing as 2099 in my reports... [message #88137 is a reply to message #88125] Sun, 07 April 2002 22:56 Go to previous messageGo to next message
Ayan
Messages: 11
Registered: February 2002
Junior Member
use format mask RRRR for year. It will display anything between 50 and 99 as 19XX ane anything between 1 and 49 as 20XX

Hope this will help you
Ayan

Report message to a moderator

Re: very urgent .....year 1999 recods appearing as 2099 in my reports... [message #88173 is a reply to message #88125] Wed, 24 April 2002 05:12 Go to previous message
arun kumar
Messages: 13
Registered: April 2002
Junior Member
USE TO_CHAR(HIREDATE,'DD-MON-RRRR')

Report message to a moderator

Previous Topic: If any one champion in report , I will appreciate
Next Topic: Re: Reports 2.5 and report to File
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 17 16:24:29 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.