Interested to Buy Any Domain ? << Click Here >> for more details...
convert yyyy mm dd to dd mm yyyy?
- 4 Answers
- 16387 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 |
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
How To find the location of APT_confid file
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How you Implemented SCD Type 1 & Type 2 in your project?
Name the different sorting methods in datastage.
How many types of stage?
Notification Activity
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
Teradata 
