RosettaCodeData/Task/Roman-numerals-Encode/SQL/roman-numerals-encode.sql

10 lines
242 B
MySQL
Raw Permalink Normal View History

2013-04-10 23:57:08 -07:00
--
-- This only works under Oracle and has the limitation of 1 to 3999
2016-12-05 22:15:40 +01:00
SQL> select to_char(1666, 'RN') urcoman, to_char(1666, 'rn') lcroman from dual;
2013-04-10 23:57:08 -07:00
2016-12-05 22:15:40 +01:00
URCOMAN LCROMAN
--------------- ---------------
MDCLXVI mdclxvi