Home
Topics
(Move to ...)
Home
About Me
SQL LOADER / UNIX Scripts (2)
Interview
JS
Sudoku
Application & Performance (4)
Blog
sql / plsql
AOL
Generic
OM / O2C
AP & CM
HRMS
PO
▼
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
))
?>
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment