Interested to Buy Any Domain ? << Click Here >> for more details...
convert yyyy mm dd to dd mm yyyy?
- 4 Answers
- 16019 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 |
How to add zero "0" before record in a field?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
what is A Datastage?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What is the difference between the local container and shared container?
What are routines in datastage? Enlist various types of routines.
What are the different database update actions available?
why we use parameters instead of hard code in datastage
How to move data set from one server to other?what are the steps to follow to do this?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Teradata 
