OraFAQ Forum: SQL & PL/SQL » Year in Roman Numerals

Home » SQL & PL/SQL » SQL & PL/SQL » Year in Roman Numerals

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Year in Roman Numerals [message #23436]

Mon, 09 December 2002 10:45

Arathi
Messages: 9
Registered: November 2002

Junior Member

Hello,
Is it possible to display the year in Roman Numerals .. ex MCMXC ??

Report message to a moderator

Re: Year in Roman Numerals [message #23438 is a reply to message #23436]

Mon, 09 December 2002 10:52

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql>select to_char(to_char(sysdate, 'yyyy'), 'FMRN') from dual;
 
TO_CHAR(TO_CHAR
---------------
MMII
 
1 row selected.
 
sql>select to_char(to_char(add_months(sysdate, -36), 'yyyy'), 'FMRN') from dual;
 
TO_CHAR(TO_CHAR
---------------
MCMXCIX
 
1 row selected.
 
sql>select to_char(1966, 'FMRN') from dual;
 
TO_CHAR(1966,'F
---------------
MCMLXVI
 
1 row selected.

Report message to a moderator

Previous Topic:	regarding users information
Next Topic:	How to select recusrsively in an sql statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 08:52:01 CDT 2024