-
SQLLDR Friday Challenge......
Hi,
I have a challenge to overcome in SQLLDR.
I have a column TIME_AT_ADDRESS with an input format of YYMM, where YY is the number of years, and MM is the number of months at address.
I need to convert it to number of months, so 0311 (3 years, 11 months) becomes 47 (months)
However, the default value of 9999 needs to be preserved without conversion.
Can this be done purely in SQLLDR ??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|