Interested to Buy Any Domain ? << Click Here >> for more details...
convert yyyy mm dd to dd mm yyyy?
- 4 Answers
- 16175 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 |
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
Differentiate between operational datastage (ods) and data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is a quality stage?
Wat is isolation level and when do u use them?
What could be a data source system?
What is the precedence of stage variables,derivations, and constraints?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
What is the flow of loading data into fact & dimensional tables?
What a datastage macro?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
Teradata 
