Interested to Buy Any Domain ? << Click Here >> for more details...
convert yyyy mm dd to dd mm yyyy?
- 4 Answers
- 16089 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vivek nigam
If the datatype of the input is date then you need to
convert it to Char and the you can formulate it to Date
with the new format.
to_date(to_char(<Input Field>,'dd-m-yyyy'))
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jerry
to_date(to_char(Field_Name,'dd-mm-yyyy'),'dd/mm/yyyy');
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ashok
using field we can cut yyyy,mm,dd as separate and using
concat we can combine as dd mm yyyy
| Is This Answer Correct ? | 4 Yes | 6 No |
How to clean the datastage repository?
Difference between data warehousing and olap?
What is the difference between in process and inter process?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
State the difference between an operational datastage and a data warehouse?
how to find diff between 2 dates without using Icon... funtions?
How to use Environment variable's in datastage?(use of process)
What is usage analysis in datastage?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
what r the sources u need to create the datastage?
Teradata 
