My source is this
year
01/jun/2014
04/may/2015
09/mar/2017
my desired output is
day month ye
01 jun 2014
04 may 2015
09 mar 2017
how do i acheive this
Answer Posted / isha
to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What is a joiner transformation and why it is an active one?
Differentiate between a database and data warehouse?
What do think which one is the better joiner or look up?
what is $$$$?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
In informatics server which files are created during the session rums?
What is a pre-defined event and user-defined event?
What are the differences between joiner transformation and source qualifier transformation?
Enlist the advantages of informatica.
How can a transformation be made reusable?
How does a sorter cache works?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do you understand by a term domain?
hi real timers . iam waiting for ur reply regarding ETL TESTING