Interested to Buy Any Domain ? << Click Here >> for more details...
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec-
2007 or 20-dec-07 in parallel
- 3 Answers
- 9563 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasad
use column datatype as varchar
DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')
use above format in derivation for transformer stage, u will get the desired output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Where do the datastage jobs get stored?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is quality stage?
What are the different types of lookups in datastage?
Define repository tables in datastage?
How to find value from a column in a dataset?
Is possible to create skid in dim,fact tables?
What is process model?
What is the purpose of interprocessor stage in server jobs?
Describe link sort?
What are stage variables and constants?
What is size of a transaction and an array means in a datastage?
What is aggtorec restructure operator?
how to export or import the jobs in .ISX file
What all are the different way to run a job?
