Author |
Message |
Topic: SQL Challenge - II |
mummanen
Replies: 8
Views: 14252
|
Forum: Mainframe Challenge Posted: Wed Aug 24, 2005 12:09 pm Subject: SQL Challenge - II |
I didn't realize that you are talking about only DB2 SQL's. |
Topic: SQL Challenge - II |
mummanen
Replies: 8
Views: 14252
|
Forum: Mainframe Challenge Posted: Tue Aug 23, 2005 4:09 pm Subject: SQL Challenge - II |
The below SQL will work for differance between two dates:
select round(months_between(to_date('2005-01-03', 'YYYY-MM-DD'),to_date('2004-05-01', 'YYYY-MM-DD')))
from dual; |
Topic: How to convert numeric number to roman number? |
mummanen
Replies: 4
Views: 3642
|
Forum: Application Programming Posted: Mon Feb 02, 2004 4:29 pm Subject: How to convert numeric number to roman number? |
Did anybody have some example code for converting numeric number to roman number?
I did through the SQL query embedded into my cobol program
select to_char(11,'RN') from dual; |
Topic: How to convert numeric number to roman number? |
mummanen
Replies: 4
Views: 3642
|
Forum: Application Programming Posted: Mon Feb 02, 2004 2:55 pm Subject: How to convert numeric number to roman number? |
How to convert numeric number to roman number in MF COBOL?
Do we have any function for this?
EX: 1 = I, 2 = II, 3 = III ... 10 = X etc... |
|