Interested to Buy Any Domain ? << Click Here >> for more details...
convert yyyy mm dd to dd mm yyyy?
- 4 Answers
- 16009 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 |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
What is the difference between an operational datastage and a data warehouse?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How do you generate sequence number in datastage?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
AGGREGATOR default datatype
Enlist various types of routines in datastage.
Why fact table is in normal form?
What is the difference between informatica and datastage?
Which commands are used to import and export the datastage jobs?
How can we do null handling in sequential files
Teradata 
