All
I had an issue with date conversion
My source file has date formet 'mmddyy' and i need to send to target in other formet lilke mmdd18yy
means everytime i have to add 18 to source data and send the data
Is there any function in ds do this for me or should need to write any routine for this.
please suggest me on this issue.
Thanks
date conversion issue
Moderators: chulett, rschirm, roy
Re: date conversion issue
In Transformer do derivation as
Left(cloumn_name,4):18:right(cloumn_name,2)
I had an issue with date conversion
My source file has date formet 'mmddyy' and i need to send to target in other formet lilke mmdd18yy
means everytime i have to add 18 to source data and send the data
Is there any function in ds do this for me or should need to write any routine for this.
please suggest me on this issue.
Thanks[/quote]
Left(cloumn_name,4):18:right(cloumn_name,2)
I had an issue with date conversion
My source file has date formet 'mmddyy' and i need to send to target in other formet lilke mmdd18yy
means everytime i have to add 18 to source data and send the data
Is there any function in ds do this for me or should need to write any routine for this.
please suggest me on this issue.
Thanks[/quote]
Thanks Man
Thanks a lotkumar_s wrote:Since you are doing a string Manupulation, add qoute around 18 from the given solution.
Left(cloumn_name,4):'18':right(cloumn_name,2) ...
can we have any routine to do this, b'cos i have to use this in diffrent jobs
Thanks
Do you mean to say, you need to perform this task in various other jobs as well. Include the same statment in other jobs as well. Ofcouse you can write a routine, but its not that effective or this single liner.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Do you mean to say, you need to perform this task in various other jobs as well. Include the same statment in other jobs as well. Ofcouse you can write a routine, but its not that effective or this single liner.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One point of clarification: are you intending to prepend 18 to any two digit year? OR do you need to add either 18 days or 18 years to the existing date? If you are prepending 18 to the YY supplied, you are stating you want all of the year portions of a date to be in the 19th century.
Guess I'm just curious as to why??
Guess I'm just curious as to why??
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"