convert yyyy mm dd to dd mm yyyy?
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 |
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
What is Cleanup Resources and when do you use it?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
What are operators in datastage?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
HOW CAN WE SEE THE DATA IN DATASET?
Have you used Unstructured data?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
How did you reconcile source with target?
table actions available in oracle connector?