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...

write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009

i want the output
date
11-mar-2010
30-may-2010

Answer Posted / gyana

u can use the TODATE() function to make it as default date
and time

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577


What are the prerequisite tasks to achieve the session partition?

1295


How can we update a record in the target table without using update strategy?

1201


State the differences between sql override and lookup override?

1283


How do you handle two sessions in Informatica

1217


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2245


what are factless facts? And in which scenario will you use such kinds of fact tables.

1855


can we override a native sql query within informatica? Where do we do it? How do we do it?

1111


What is an unconnected transformation?

1129


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2020


explain abt ur project architecture?

2232


Do you find any difficulty while working with flat files as source and target?

1146


can you please explain me pre session and post session options?

7670


Can we change Dynamic to Static or Persistent cache? If so what happens?

2248


How do you manage the Parameter files while migrating your data from one environment to another environment?

1067