add
About Me
Jithendra Kumar B
Oracle Apps - Techno Functional consultant
View my complete profile
Tuesday, June 25
Formating Date From 'YYYY/MM/DD' to 'DD-MON-YYYY' in XMLP(RTF)
<?
xdofx:
(
substr
(
PAYMENT_DATE
,
9
,
2
)||
'-'
||
decode
(
substr
(
PAYMENT_DATE
,
6
,
2
),
'01'
,
'JAN'
,
'02'
,
'FEB'
,
'03'
,
'MAR'
,
'04'
,
'APR'
,
'05'
,
'MAY'
,
'06'
,
'JUN'
,
'07'
,
'JUL'
,
'08'
,
'AUG'
,
'09'
,
'SEP'
,
'10'
,
'OCT'
,
'11'
,
'NOV'
,
'12'
,
'DEC'
)||
'-'
||
substr
(
PAYMENT_DATE
,
1
,
4
))
?>
Related Posts :
XMLP
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment