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 |
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
what is the definitions for Datawarehose and Datamart?
How can we run same job in 1 day 2 times
What is difference between server jobs & parallel jobs?
Can you explain link buffering?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
How to manage date conversion in Datastage?
what is sparse lookup?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
How we can covert server job to a parallel job?
How complex jobs are implemented in datstage to improve performance?
what is use of SDR function?