Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what is the -ve test case in your project.

2458


What is a repository manager?

1148


What is the benefit of partitioning a session?

1235


Explain in detail scd type 2 through mapping.

1091


What is Cognos script editor?

4287


What is an unconnected transformation?

1130


What is complex mapping?

1171


What are mapplets? How is it different from a Reusable Transformation?

1136


What is a surrogate key?

1154


What does “tail –f” command do and what is its use as an Informatica admin.

1147


what is index?how it can work in informatica

2083


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2404


which one is better performance wise joiner or look up

1149


What is different between the data warehouse and data mart?

1113


What is DR strategy for Informatica project?

1225