Had a recent requirement to convert a credit card expiration date from MMYY to YYYY-MM-DD so that it could be sorted upon in Salesforce. Fortunately, I only had to modify the view in Oracle to the following:
select
DECODE(
NVL(myColumn,'N/A'),
'N/A',
'N/A',
to_char(last_day(to_date(myColumn,'MMYY')),'YYYY-MM-DD')
)
from myTable
No comments:
Post a Comment